pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Problem 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>
  2000-06-14 07:19 ` Re: Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access Jason Doller <rjd@intekom.co.za>
  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-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>
  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