Help troubleshooting Access linked tables - Mailing list pgsql-odbc

From Luke Pond
Subject Help troubleshooting Access linked tables
Date
Msg-id 075901c33384$c1acc1d0$6401a8c0@REPINIQUE
Whole thread Raw
List pgsql-odbc
Hi,

I have upgraded to the latest stable release of pgAdmin II and psqlODBC
(driver version 7.03.01).  I moved two tables from an access application to
my postgresql 7.2.4 database, and can view the data in them via pgAdmin or
psql on the server.

My goal is to use linked tables in Access 2000, and setting up the DSN and
linking to the two tables worked fine.  But when I open the linked tables, I
get a message that says "ODBC - call failed", and every column in the table
has the text "#Deleted" or "#Name?" in it, rather than my data.  Does anyone
know what this indicates?

I've looked in mylog_xxxx.log and psqlodbc_xxxx.log and there are no error
messages there.

thanks,
Luke Pond
dlpond@pobox.com



pgsql-odbc by date:

Previous
From: Andreas Pflug
Date:
Subject: ResolveNumericParam problem
Next
From: Ferran Pegueroles
Date:
Subject: Re: [Tiny-cobol-users] New compiler options RFC