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

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

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: noreplyDate: 2012-02-07 13:20:19
Subject: [ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms
Previous:From: Fred ParkinsonDate: 2012-01-27 15:32:46
Subject: odbc link keep losing it senses

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