Problems connecting to ODBC in Vista x64
652980Jul 31 2008 — edited Aug 6 2008I connect through Microsoft's ODBC driver for Oracle on Windows XP and Windows Vista 32 bit Business fine, but when I run the program on the 64 bit version of Vista I get "DSN not found" message. I have tried placing the "c:\windows\sysWOW64" directory in the front of the path environment but this does not work either. Any ideas on how to get this to work?
I am using ADODB to connect. We are running Oracle 9 on the server.
dataDB.Open("DRIVER={Microsoft ODBC for Oracle};SERVER=bu.server.world;UID=happy;PWD=joy;")
We have the driver set up in the sysWOW64 folder, but for some reason the program cannot see it at all. We have also tried moving the sysWOW64 directory to the front in the path of the system.