pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access
2+ messages / 2 participants
[nested] [flat]
* Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access
@ 2000-06-13 08:40 Jeroen Buskens <jeroen.buskens@cmg.nl>
0 siblings, 1 reply; 2+ messages in thread
From: Jeroen Buskens @ 2000-06-13 08:40 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
I ran into a problem connecting to PostgreSQL 7.0 using ODBC. So far with a
6.5 database everything worked fine.
I installed 7.0 on a new machine, but when trying to make an ODBC connection
from Access 97, I get an error (something like 'cannot connect to port
#101'). Yesterday I updated the database to version 7.0.2 (and made sure
that I included ODBC support during compilation), but the ODBC driver still
gives the same error. Since 7.0.2 interactive postgresql is not working
anymore either (did work with 7.0). It does not give any error.
Jeroen
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access
@ 2000-06-14 07:19 Jason Doller <rjd@intekom.co.za>
parent: Jeroen Buskens <jeroen.buskens@cmg.nl>
0 siblings, 0 replies; 2+ messages in thread
From: Jason Doller @ 2000-06-14 07:19 UTC (permalink / raw)
To: pgsql-interfaces
Hi All
I am also having problems with ODBC and Access.
Linked tables I created before the upgrade (from 6.5.?) work fine.
Linked tables created AFTER the upgrade (to 7.0.2) allow adding of
records, but not deleting or modifying of records.
Any suggestions? I have tried with both 6.5 and 6.40.009 versions of
ODBC.
Cheers
Jason Doller
On 13 Jun 2000, at 10:40, Jeroen Buskens wrote:
> Hi,
>
> I ran into a problem connecting to PostgreSQL 7.0 using ODBC. So far with a
> 6.5 database everything worked fine.
> I installed 7.0 on a new machine, but when trying to make an ODBC connection
> from Access 97, I get an error (something like 'cannot connect to port
> #101'). Yesterday I updated the database to version 7.0.2 (and made sure
> that I included ODBC support during compilation), but the ODBC driver still
> gives the same error. Since 7.0.2 interactive postgresql is not working
> anymore either (did work with 7.0). It does not give any error.
>
> Jeroen
>
- - - - - - - - - - - - - - - - - - - -
Microso~1 : For when Quality, Reliability and Security
just aren't that important.
(Shamelessly stolen from soneone on the Kernel mailing list)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-06-14 07:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-13 08:40 Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access Jeroen Buskens <jeroen.buskens@cmg.nl>
2000-06-14 07:19 ` Jason Doller <rjd@intekom.co.za>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox