Hi all!
I have an Access 2000 database (under Windows 2000) which has tables linked
from a PostgreSQL database. These tables have been linked using the
PostgreSQL ODBC driver 7.01.0004 or some version around that (sorry, I don't
remember the exact version). The Access ODBC connect string of one table is:
ODBC;DSN=lmdb;DATABASE=lmdb;SERVER=sphinx.link-m.de;PORT=5432;
UID=lmdb;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;
ROWVERSIONING=1;SHOWSYSTEMTABLES=0;CONNSETTINGS=;TABLE=**Logfile
However, I have now installed a newer version of the ODBC driver
(7.01.0009), and when I create a new table link for the *same* table, I get
quite a different ODBC connect string:
ODBC;DSN=lmdb;DATABASE=lmdb;SERVER=sphinx.link-m.de;PORT=5432;
A0=0;A1=6.4;A2=0;A3=0;A4=1;A5=0;A6=;A7=100;A8=4096;A9=0;B0=254;
B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=0;C0=0;C1=0; C2=dd_;;TABLE=**Logfile
Questions:
* Did the ODBC connect string format indeed change between ODBC driver
versions?
* Can I still use the old format with newer ODBC drivers without having to
expect any disadvantages or bugs?
* Is the new format better? (It seems to include more of the parameters that
can be set in the Windows ODBC control panel applet for the PostgreSQL ODBC
driver, but on the other hand, it seems to miss parameters, like "UID".)
This really confuses me, and I would appreciate any insights you can give
me!
Thanks in advance,
Julian Mehnle.
--
Linksystem Muenchen GmbH info@link-m.de
Schloerstrasse 10 http://www.link-m.de
80634 Muenchen Tel. 089 / 890 518-0
We make the Net work. Fax 089 / 890 518-77
