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

Re: Connecting between Postgres(linux) and Access97

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Connecting between Postgres(linux) and Access97
Date: 2006-11-06 19:10:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Why do you want to do this?  There are a couple of problems I see with this approach
1) Even if you could get an access ODBC driver to work on SUSE, you have the network path issue problem which is a pain to get working even in a pure windows environment.  
2) Access 97 is a wee bit obsolete - that doesn't matter too much here I guess - but it is 3 versions behind (there is Access 2000, Access 2002, and Access 2003 that all came after it).
-- Getting back to some solutions  --
1) It is much easier to get Access to talk to PostGres than it is to get Python/Unix to talk to Access.
Do you have the option of just moving all your access data to PostGres, replacing the access tables with linked PostGres tables and install a Pg ODBC driver on your windows 2000 pc.  The forms etc. should pretty much work as is except for some case-sensitive issues, which I think there are workarounds for.

From: pgsql-odbc-owner(at)postgresql(dot)org on behalf of David Sturtevant
Sent: Thu 11/2/2006 7:26 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Connecting between Postgres(linux) and Access97


I am looking for help/advice about connecting  postgresql(ver 8.1.4) located on suse10.1 and an Access97 database located on windows 2000 service pack 4, using using python 2.4.2 which is located on the same suse10.1 box as the postgres database

I have looked into ways to connect these systems, and I am having trouble connecting to the Access97 database.  

I have tried adodb for python, utilizing mxodbc and iODBC, and mounting the folder that the Access database is located on using a samba mount; but on searching through the adodb docs it turns out that this only works on a Windows machine (so I believe).  Can anyone recommend a way for me to carry this out?  I found a project called mdbtools, that used to be associated with UNIXODBC but this appears to be a stopped project that finished before they achieved write capabilities to the mdb file. (and the UNIXODBC project only has software that comes with 30days evaluation to achieve this now).  

I am new to this type of work and any feedback would be greatly appreciated,


David James

The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.

In response to


pgsql-odbc by date

Next:From: Peter EisentrautDate: 2006-11-06 19:46:15
Subject: Fwd: Bug#396218: bind.c: bad handling of SQL_LEN_DATA_AT_EXEC breaks passing char buffer length at SQLExec time
Previous:From: Hiroshi InoueDate: 2006-11-03 21:33:28
Subject: Re: Driver doesn't work without --enable-pthreads

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