Skip site navigation (1) Skip section navigation (2)

Re: Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access

From: "Jason Doller" <rjd(at)intekom(dot)co(dot)za>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access
Date: 2000-06-14 07:19:46
Message-ID: 39474E32.32267.AACA239@localhost (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2000-06-14 15:21:36
Subject: Re: ecpg: how select/insert n rows (array) in one query
Previous:From: selkovjrDate: 2000-06-14 06:32:06
Subject: Re: Ayuda

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group