From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms |
Date: | 2012-02-07 13:14:14 |
Message-ID: | 20120207131415.25A861613625@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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)"
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011159&group_id=1000125
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2012-02-07 13:20:19 | [ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms |
Previous Message | Fred Parkinson | 2012-01-27 15:32:46 | odbc link keep losing it senses |