Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to Oracle Server Version 7.3.2.1 through ODBC

315667Jul 31 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2002
Added on Jul 31 2002
4 comments
385 views