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
theregular name "PostgreSql Unicode" but MS Access 64bit must use "PostgreSql Unicode(x64)". This requires us to
provide2 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\PostgreSQLUnicode(x64)"
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode" >> to
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQLUnicode(x64)"
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL ANSI" >> to
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQLANSI(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
