From: "Jason Doller" <rjd@intekom.co.za>
To: pgsql-interfaces@postgresql.org
Date: Wed, 14 Jun 2000 09:19:46 +0200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: Problem with ODBC (6.50), PostgreSQL 7.0.2 and MS Access
Reply-to: rjd@intekom.co.za
Message-ID: <39474E32.32267.AACA239@localhost>
In-reply-to: <797E8E172D4ED211B90200104BB3F77CCD0A80@nl-maa-mail01.cmg.nl>

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)