Help troubleshooting Access linked tables

From: "Luke Pond" <dpond009(at)attbi(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Help troubleshooting Access linked tables
Date: 2003-06-15 21:26:16
Message-ID: 075901c33384$c1acc1d0$6401a8c0@REPINIQUE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pobox(dot)com

Browse pgsql-odbc by date

  From Date Subject
Next Message Ferran Pegueroles 2003-06-16 03:15:40 Re: [Tiny-cobol-users] New compiler options RFC
Previous Message Jarosław Jankowski 2003-06-13 15:34:07 PostgreSQL ODBC driver error when returnning more than one query (wiht Visual Foxpro)