Steve,
Have a look at the log files: C:\psqlodbc_*.log on your windows box.
Make sure your ODBC and PostgreSQL versions are not mismatched.
I've successfully connected in the past with Access 97/ Win 95 to OpenBSD
2.7 and PostgreSQL 6.5.3, but I haven't tried lately with Access 2000 and
PosstgreSQL 7.
Ciao
--Louis <louis@bertrandtech.on.ca>
Louis Bertrand http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada
Tel: +1.905.623.1500 Fax: +1.905.623.3852
OpenBSD: Secure by default. http://www.openbsd.org/
On Wed, 27 Sep 2000, Steve Quezadas wrote:
> Hello,
>
> I am new to postgres and I am having trouble hooking it up to a Microsoft
> Access database via ODBC. I am able to CONNECT to the postgres database
> server and have both tables appear in the "tables" section of Access. But
> once I double click on one of the tables in MIcrosoft Access (which is an
> empty table), all I get is a completly blank table where I can't even insert
> a record. When I try double clicking on the other table (which has a single
> record in it), Access complains "ODBC--call failed" without another
> explanation dialogue box following it. I don't know why it would fail like
> that.
>
> Here are a few questions:
> 1) Where are the postgres log files? I see pg_log in /usr/local/pgsql/data,
> but it seems to be encrypted or something
> 2) I notice in /usr/local/pgsql there is a file called "odbcinst.ini". Am I
> supposed to alter this file?
> 3) Where in the Postgres manuals does it describe how to install an ODBC
> connection. I can't seem to find it.
>
>