RE: Postgresql and ODBC > MsAccess (The answer)

[Administrador <ag...@ho...>]

Maybe the following will contribute to the question:

When we started to move applications from MS plataform to PostgreSQL. =
In the
beginning, we did a project where we researched how to connect a MS =
Access
client against ans PostgreSQL Server. This was because our user still =
want
to use MS Windows, while KDE have not an Office Application that fully =
read
and write our Word docs and Excel Spreadsheets under Linux.

First we used and rewrote a tool founded in the postgreSQL web site =
that
help to convert an Access DB to PostgreSQL. The DB convert application =
name
is "PgUpt - postgress Upsizing Toolkit". The DB was 10 MB with more =
than 50
tables. We rewrote some code of this applicartion and we sucefully did =
the
DB conversion at great Time!

After that, we start to link the DB Access Client with ODBC Driver for
PostgreSQL using "linked tables" and the result was very BAD. Every =
query
taked too mouch time. Sometimes we must wait more than 2 minutes when =
if the
same Database used MS Jet, the query was done in less than 10 seconds!

We researched what is the cause of the problem., and in a book we found =
that
"MS Access poorly interact with any ODBC driver!". If you try to get =
for
example 10 registers then Access open a connection, get ONE register =
and
close the connection, then again open a new connection, get the SECOND
register and close the connection, etc.!!!!!!

Of course if you try the same with MS SQL Server you get a better =
result!

Well, at the end. If anybody wish to write and MS Access Client to =
interact
with PostgreSQL using the native way. He must rewrite the app to get a
better performance.

I hope this will help anyone who wish to write an MS Access client for
SQL-Ledger.

Regards,

Antonio Gallardo





> -----Mensaje original-----
> De:	Oscar Buijten [SMTP:os...@el...]
> Enviado el:	jueves 21 de junio de 2001 1:28
> Para:	sql...@li...
> Asunto:	Re: Postgresql and ODBC > MsAccess (The answer)
>=20
> For those who are interested:
>=20
> If you would like to access your Postgresql server on your linux (or
> whatever else box) from MickeySoft Access you will need to install =
the
> Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be
> carefull, it might be bussy on this site)
>=20
> ftp.postgresql.org=20
>=20
> and move to pub/
> Download the .html and .txt files there for your reference.
>=20
> Then move to full/
>=20
> and download: psqlodbc-07_01_0005.zip
>=20
> unzip, doubleclick and off you go.
>=20
> To access your Pg Dbase from MsAccess97:
>=20
> Open a new database, in tables click on new.
> Select: attach table and click OK.
> A new window will open. Fromfile type, select: ODBC
> A new window will open.
> Next to the DSN name field you click on NEW.
> A new window will open. Select PostgreSQL, click next
> Now fill in the name of the new DSN entry you are about to make.
> The name of the Dbase you are going to access on Postgrqsql will do =
in
> most cases.
> Click on next and then on finish.
> A new window will open.
> This one looks very simalar to the user id in SQL ledger doesn't it?
> Fill in the details (you may want to peek into the advanced settings =
while
> you'r there) and off you go!
>=20
> Enjoy,
>=20
> Oscar
>=20
>=20
> ----- Message d'origine -----=20
>   De : Oscar Buijten=20
>   =C0 : sql...@li...=20
>   Envoy=E9 : mercredi 20 juin 2001 12:08
>   Objet : Postgresql and ODBC > MsAccess
>=20
>=20
>   Hello all,
>=20
>   Realising that thismay not be the perfect place to ask my question =
I
> want to give it a try anyway.
>   I currently have information stored in a Access97 database.
>   Part of this information I would need to transfer to Postgresql (on =
a
> linux box (Mandrake 8.0) to use it in the SQL-ledger.
>=20
>   Question is: how to do this?
>=20
>   I assume I would need to do it using ODBC, but I have no clue what =
to
> install (as a driver) and
>   where to install it (on the linux box or on the wondoze box).
>=20
>   Does anyone has a good answer on this?
>=20
>   Thanks in advance!
>=20
>   Regards,
>=20
>   Oscar
>   =
________________________________________________________________________=

>=20
>   Oscar Buijten
>=20
>   Tel:     +33.4.67.57.97.45
>   Fax:    +33.4.67.57.97.46
>   GSM: +33.6.20.84.15.22
>   Email: os...@el...
>=20
>   http://www.elbie.com <<Archivo: ATT00001.htm>>=20