Connecting to Oracle Server Version 7.3.2.1 through ODBC
Hello,
I need to connect to an Oracle DB Server (7.3.2.1) running on HP-UX from a Windows machine through ODBC.
I downloaded the latest Oracle Client (9.2) und installed it on the client machine. After that I used the Oracle Net Manager to set up a Naming Service. When choosing the Test Service functionality I get a "successful".
But when I try to set up an ODBC Datasource things are going wrong. I chose the TNS Service Name as defined before, enter datasource name etc... When clicking on Test Connection I get a dialog where I enter login/pwd. When I confirm this dialog the ODBC Administrator hangs and I need to kill the process.
If I define the ODBC Datasource without testing in the ODBC Administrator and try to connect to it through some SQL Client Tool (i.e. Delphi DB Explorer) the client tool hangs, too.
Further I tried to connect to the DB using JDBC (thin) just to make sure, that there is no network problems. This works without trouble.
Do I miss something in the ODBC configuration ? Thanks for every help in advance.
best regards
-Andreas