My SQLNET.ORA looks like this
LOG_FILE_CLIENT = sqlnet.log
AUTOMATIC_IPC = OFF
NAMES.DIRECTORY_PATH = TNSNAMES
SQLNET.AUTHENTICATION_SERV
LOG_DIRECTORY_CLIENT = c:\Oracle\Ora81\logs
SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp
TNSPING.TRACE_LEVEL = 4
The mystery deepens because I have also tried the following:
1) In VB, do ChDir "C:\Oracle\Ora81\Network\A
cn.Open "DSN=MYDB"
Same problem
2) Change TNSNAMES.ORA to use a SERVICE_NAME instead of a SID
DBD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mydb.mydomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYDB.mydomain.com)
)
)
Same problem. (It works either way through SQL*Plus or TNSPING)
3) Change the line in SQLNET.ORA
SQLNET.AUTHENTICATION_SERV
Same Problem
4) In VB, change to a DSN-Less connection
cn.Open "Provider=MSDASQL;DRIVER={
Same problem
5) Test the DSN using the Oracle ODBC Test Program.
Same problem
6) Create a DSN using the Oracle ODBC Driver
This works fine from both VB and the Oracle ODBC Test Program
Main Topics
Browse All Topics





by: anand_2000vPosted on 2003-06-25 at 09:26:44ID: 8798882
can u post the info about ur sqlnet.ora file