Connecting between Postgres(linux) and Access97

------=_Part_2213_13571881.1162470363530
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,

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,

Thanks

David James

------=_Part_2213_13571881.1162470363530
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,

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,

Thanks

David James


------=_Part_2213_13571881.1162470363530--

Re: Connecting between Postgres(linux) and Access97

This is a multi-part message in MIME format.


------_=_NextPart_001_01C701D7.376AEB64
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 SU=
SE, 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 b=
it obsolete - that doesn't matter too much here I guess - but it is 3 versi=
ons behind (there is Access 2000, Access 2002, and Access 2003 that all cam=
e after it). =0A -- 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. =0A 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 Th=
e forms etc should pretty much work as is except for some case-sensitive=
issues, which I think there are workarounds for. =0A Thanks,=0D=
=0ARegina ________________________________ Fr=
om: pgsql-odbc-owner@postgresqlorg on behalf of David Sturtevant Se=
nt: Thu 11/2/2006 7:26 AM To: pgsql-odbc@postgresqlorg Subject=
: [ODBC] Connecting between Postgres(linux) and Access97 H=
ello, I am looking for help/advice about connecting postgresql(=
ver 814) located on suse101 and an Access97 database located on wi=
ndows 2000 service pack 4, using using python 242 which is located on=
the same suse101 box as the postgres database I have looked =
into ways to connect these systems, and I am having trouble connecting to t=
he Access97 database I have tried adodb for python, utilizi=
ng mxodbc and iODBC, and mounting the folder that the Access database is lo=
cated on using a samba mount; but on searching through the adodb docs it tu=
rns out that this only works on a Windows machine (so I believe) Can an=
yone recommend a way for me to carry this out? I found a project called md=
btools, that used to be associated with UNIXODBC but this appears to be a s=
topped project that finished before they achieved write capabilities to the=
mdb file (and the UNIXODBC project only has software that comes with 30=
days evaluation to achieve this now) I am new to this type =
of work and any feedback would be greatly appreciated, Thanks=0D=
=0ADavid James ------------------------- =
---------------- The substance of this message, including any attachme=
nts, may be confidential, legally privileged and/or exempt from d=
isclosure 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. =0A
------_=_NextPart_001_01C701D7.376AEB64
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=0A r=3Dltr> et=3Dunicode">=0A ATOR>=0A=0A