ODBC connect string format differs between ODBC driver versions?

From: "Julian Mehnle, Linksystem Muenchen" <j(dot)mehnle(at)buero(dot)link-m(dot)de>
To: pgsql-hackers(at)postgresql(dot)org(dot)pgsql-odbc(at)postgresql(dot)org
Subject: ODBC connect string format differs between ODBC driver versions?
Date: 2001-12-29 15:58:54
Message-ID: a0kp62$2gj6$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)link-m(dot)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-12-29 16:54:09 Re: text -> time cast problem
Previous Message Pavlo Baron 2001-12-29 12:09:58 Re: TODO question