[ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms

Bugs item #1011159, was opened at 2012-02-07 14:14
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011159&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Jochen Wezel (jwezel)
Assigned to: Nobody (None)
Summary: ODBC driver names on 64bit platforms

Initial Comment:
On x84 and x64 systems, psqlodbc.msi installs 2 odbc drivers called
- "PostgreSql ANSI"
- "PostgreSql Unicode"

On x64 systems, psqlodbc_x64.msi installs 2 odbc drivers called
- "PostgreSql ANSI(x64)"
- "PostgreSql Unicode(x64)"

As a result,
1. the driver name "PostgreSql" (which is often used in connection string examples on the web) doesn't work
2. the driver name differs on x64 machines for applications running in x86 mode or x64 mode. MS Access 32bit can use the regular name "PostgreSql Unicode" but MS Access 64bit must use "PostgreSql Unicode(x64)". This requires us to provide 2 database files for both platforms.

Suggested, simple solution:

for 32bit-drivers:
- Create 1 registry link (e.g. in setup files psqlodbc.msi) pointing from "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL" to "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode"

for 64bit-drivers:
- Create following 3 registry links (e.g. in setup file psqlodbc_x64.msi)
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL" >> to "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode(x64)"
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode" >> to "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode(x64)"
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL ANSI" >> to "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL ANSI(x64)"

----------------------------------------------------------------------

>Comment By: Jochen Wezel (jwezel)
Date: 2012-02-07 14:20

Message:
A first start on registry symbolic links is at:
http://www.tenox.tc/out/regln.txt

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011159&group_id=1000125