Strange ODBC problem with 64 bit (x64) 10.2 client

Hi,

I'm encountering a strange problem with the 64 bit ODBC driver that comes with the 64 bit (x64) 10.2 client. I have installed the client and that all went fine, and I can use sqlplus to access my databases.

Now, I have setup an ODBC datasource using the Oracle ODBC driver that gets installed and if I click on the Test button and provide correct login information I get connected just fine.

So, now if I attempt to use this ODBC datasource from a 64 bit program that I am writing, I get the following error message :

[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified.

I'm know my program is ok because I have tested it with other ODBC drivers and they work. I can't seem to determine what exactly I'm missing that is making this not work. I have set the environment variables TNS_ADMIN and ORACLE_HOME to point to the correct places - I think, but that doesn't help. Also, the Oracle \bin directory is in the path as I thnk it should be.

I'm stumped. Does anybody have any idea what could be the problem here ?

Thanks,
Nick Received on Fri Jan 13 2006 - 16:30:47 CST