Thread: ODBC on Vista 64

ODBC on Vista 64

From
Shoaib Naazir
Date:
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



Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!

Re: ODBC on Vista 64

From
"Hiroshi Saito"
Date:
Hi.

Please use here.
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
However, Only the AMD64 edition is prepared...

Regards,
Hiroshi Saito

----- Original Message -----
From: "Shoaib Naazir" <je_shoaib@hotmail.com>
To: <pgsql-odbc@postgresql.org>
Sent: Saturday, September 01, 2007 12:59 AM
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!!


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



Re: ODBC on Vista 64

From
"Obe, Regina"
Date:
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

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



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.