ODBC issues on Server 2003 X64

[dandemanau]

Hi, we are running PSQL 9.5 Sp2 on server 2003 x64. WE have odbc drivers under the ODBC administrator in start,programs pervasive program group but no drivers in the control panel, administrative tools, odbc. Because we have no drivers present there we cannot create any dsn's that we can use to connect to the database. Because of this we have to run an application to update our database tables on another server which is slow and not preferred.

ODBC connections setup in the PSQL control center can be seen or connected to from our other servers and pcs just fine but not on 64 bit server itself. Has anyone come across this issue b4 and if so how did you get around the problem. thanks Dan Kerr

 

[mirtheil]

Make sure you go into the 32 bit ODBC Administrator. The default ODBC Administrator is the 64 bit one. Because PSQL is 32 bit, the drivers won't show up in the 64 bit ODBC Administrator.
The ODBC ADministrator that's in the PCC is the 32 bit version and should work correctly.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com