Re: ODBC on Vista 64

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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Shoaib Naazir
Sent: Friday, August 31, 2007 12:00 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] ODBC on Vista 64

Hi,
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!!

Beta Tester Badge
2<http://www.windowslive-hotmail.com/betathanks/download/images/download
_2.jpg>

________________________________

Invite your mail contacts to join your friends list with Windows Live
Spaces. It's easy! Try it!
<http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.
aspx&mkt=en-us>

-----------------------------------------
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.