Evening all,
I have a similar problem
Running XP x64 and have installed office 2003 onto the PC
All the apps I need run excel for when I have a spread sheet that requires the ODBC connection to a Oracle database.
I have installed the 32bit and 64bit Oracle client, yet it refuses to run.
I get 2 errors:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connection identifier specified
Then:
[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed
Then I get a prompt for the username, password and server.
In the 32bit Data Source Administrator I can connect to the server through the System DNS.
Why on earth can I not connect using Excel.
I have read: The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system
Yet I cannot make heads or tails of whats needed.
Any input or help would be greatful.
Many Thanks,
V1K45
I have a similar problem
Running XP x64 and have installed office 2003 onto the PC
All the apps I need run excel for when I have a spread sheet that requires the ODBC connection to a Oracle database.
I have installed the 32bit and 64bit Oracle client, yet it refuses to run.
I get 2 errors:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connection identifier specified
Then:
[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed
Then I get a prompt for the username, password and server.
In the 32bit Data Source Administrator I can connect to the server through the System DNS.
Why on earth can I not connect using Excel.
I have read: The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system
Yet I cannot make heads or tails of whats needed.
Any input or help would be greatful.
Many Thanks,
V1K45