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

Re: ODBC connect string format differs between ODBC driver versions?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: "Julian Mehnle, Linksystem Muenchen" <j(dot)mehnle(at)buero(dot)link-m(dot)de>
Subject: Re: ODBC connect string format differs between ODBC driver versions?
Date: 2001-12-30 22:24:06
Message-ID: 3C2F9406.1CA920E1@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
"Julian Mehnle, Linksystem Muenchen" wrote:
> 
> 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?

Yes it was changed in 7.01.0007. Most driver options are changed
to be DSN options.

> * Can I still use the old format with newer ODBC drivers without having to
> expect any disadvantages or bugs?

Unfortunately I couldn't guarantee that the change was
bug-free. However I have seen no bug report other than
implicit *too long connect string* bug. A0=,B1= etc are
abbreviated format to shorten connect strings. Original
format READONLY= etc is still allowed.

regards,
Hiroshi Inoue

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-12-30 23:44:13
Subject: My email is fixed
Previous:From: Olivier PRENANTDate: 2001-12-30 19:12:00
Subject: Little question on owners

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