Re: ODBC on Vista 64 - Mailing list pgsql-odbc
I think there is a 64-bit version of the Postgresql driver, but you have to compile it yourself, which personally I haven't done and I'm not sure how stable it is. The one on the site is the 32-bit one which I think gets installed in the C:\Program Files (x86) of a 64 bit machine. To see it you need to pull up the 32 bit ODBC manager instead of the 64-bit ODBC manager (sounds like you are pulling the 64 bit manager). On my windows 2003 64 bit, I run %SystemRoot%\syswow64\odbcad32.exe
I'm not sure if that is the same location on Vista.
Hope that helps,
Regina
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Shoaib Naazir
Sent: Friday, August 31, 2007 12:00 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ODBC on Vista 64
I have an application that uses ODBC to connect to PostgreSQL. I was planning to port it to my new Vista 64bit machine but was unable to install the PostgreSQL's ODBC driver. I tried to run the ODBC msi posted at the download site, i even tried the ODBC dll's zip present at the download site but to no avail.
Do i need to do something special to run the ODBC on Vista 64 or am i missing something.
Here are the problems i faced using the two above mentioned methods:
1. MSI:
The MSI installed successfully but i couldn't find the entries in the DSN dialog neither where there any entries in the registry [HKLM\Softwares\ODBC\ODBCINST.INI].
2. DLL:
I copied the 'psqlodbc35w.dll' and 'psqlodbc35a.dll' (and all the other Dlls in the zip file) into the \Windows\System32 folder and ran the 'psqlodbc.reg' file. The entries in the DSN dialog and registry did appear but when i try to select the entry in the DSN dialog i get the following error:
"The setup routines for the PostgreSQL ANSI ODBC driver could not be loaded due to system error code 193"
closing this error dialog produces another stating
"Errors found: Could not load the setup or translator library"
As far as i googled on it. Error code: 193 is for corrupt files? What am i doing wrong??
Thanks.
Lid.
Artificial intelligence is no match for natural stupidity!!
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
pgsql-odbc by date: