about postgres odbc on wondows

Started by LitelWangabout 22 years ago5 messagesgeneral
Jump to latest
#1LitelWang
wlxyk@vip.163.com

After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?
Thanks .

#2Joshua D. Drake
jd@commandprompt.com
In reply to: LitelWang (#1)
Re: about postgres odbc on wondows

LitelWang wrote:

After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?

The different versions of the ODBC protocol they support.

Thanks .

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
#3LitelWang
wlxyk@vip.163.com
In reply to: Joshua D. Drake (#2)
Re: about postgres odbc on wondows

Can you give the details ?
Or some Web links .Thanks.
=======================================

LitelWang wrote:

After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?

The different versions of the ODBC protocol they support.

Thanks .

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

= = = = = = = = = = = = = = = = = = = =

#4Richard Huxton
dev@archonet.com
In reply to: LitelWang (#3)
Re: about postgres odbc on wondows

On Thursday 15 January 2004 06:19, LitelWang wrote:

Can you give the details ?

There are different versions of the ODBC standard (v2, v2.5, v3 ...) - IIRC
there are details somewhere on Microsoft's sites (it's their standard). If in
doubt, use the middle-one.

I believe the psqlodbc30w.dll also supports multi-byte character sets, but
don't quote me on that.

--
Richard Huxton
Archonet Ltd

#5LitelWang
wlxyk@vip.163.com
In reply to: Richard Huxton (#4)
Re: about postgres odbc on wondows

Thanks for your prompt reply .

I use psqlodbc30w.dll one week ago .But I found it caused my
Delphi client program to fail in the running progress frequently.
I replaced it with the middle one ,there was no any problem .

My database was postgres7.3.4 on redhat linux 9 .
My client program was compiled with Delphi 6(SP2) using
ADO-ODBC connection .

=======================================

On Thursday 15 January 2004 06:19, LitelWang wrote:

Can you give the details ?

There are different versions of the ODBC standard (v2, v2.5, v3 ...) - IIRC
there are details somewhere on Microsoft's sites (it's their standard). If in
doubt, use the middle-one.

I believe the psqlodbc30w.dll also supports multi-byte character sets, but
don't quote me on that.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

= = = = = = = = = = = = = = = = = = = =