getting sqlstate=08501 when testing odbc
432723Nov 11 2004 — edited Nov 19 2004I installed the 9.2.0.4 ODBC driver and the Oracle 10g client software on my PC running windows XP. I made sure that the PATH contains the directory where the client software was installed. When I test the ODBC driver I get a connection refused error of SQLState=08501 and connect ret -1 err #10061 SWAECONNREFUSED. The transport is 2-tcp/ip, server is the name of the server that contains the database, and the service is set to the tnsname for the instance.
I have not used the ODBC driver connection before. What could be missing?
Thank you for your assistance.