Connect Oracle 7.3 (SQL*Net 2.3) with SQLWindows 5.01
From: Horace Tso Lung Kwong <tsolk_at_netvigator.com>
Date: 1996/11/30
Message-ID: <329FA098.1FD4_at_netvigator.com>#1/1
Date: 1996/11/30
Message-ID: <329FA098.1FD4_at_netvigator.com>#1/1
Thanks for giving kind responses.
We are using Oracle database server 7.3.2.2, SQL*Net 2.3.2.1, and SQLWindows 5.01.
Configurations have been made as follows:
- In client c:\orawin95\bin as well as c:\orawin95\network\admin (where tnsnames.ora and sqlnet.ora placed)are in the path.
- Gupta directory c:\gupta is in the path
- oracle.ini has a line ORACLE_HOME=C:\ORAWIN95
- In SQL.INI in c:\gupta directory, a line COMDLL=sqloraw.dll is added to the [winclient.dll] section a line remotedbname=oracle, _at_t:host:oracle in [oragtwy] section in which oracle is the database name as well as the system_id (the connect string as specified in menu is remotedbname=dbname, _at_t:host:system_id)
- I can connect in client machine using SQL*Plus with no problem.
- Oracle is configured to run in dedicate mode, not MTS mode.
I can only get the error "ORA-3121 no interface driver connected" when I try to connect using SQL*Talk or else. Should anyone give me any advice, pls give a help hand. Thanks in advance.
Best regards
Devin Ho
email: devin_at_csi.com.hk
Received on Sat Nov 30 1996 - 00:00:00 CET