| what connect string? [message #67443] |
Tue, 27 July 2004 23:39  |
nasrin
Messages: 2
Registered: July 2004
|
Junior Member |
|
|
Hi
I have oracle 8.1.7 on Linux RedHat 7.3.
I need to connect to my oracle database via ODBC.
I use an oracle-odbc driver from easysoft and unixODBC.
the name of database is O817DB.
before starting to connect by ODBC I tried this:
sqlplus myuser/mypass@smsc.sms.shrif.edu:1521:O817DB
but I get this error message:
ORA-06401: NETCMN: invalid driver designator
I know that The login (connect) string contains an invalid driver designator.but IÂ don't know how to write the true connection string.
this is the tnsnames.ora file:
ORACLE.sms.sharif.edu =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.40)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = 1.1.1.40)
   )
 )
INST1_HTTP.sms.sharif.edu =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = smsc.sms.sharif.edu)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = SHARED)
     (SERVICE_NAME = smsc.sms.sharif.edu)
     (PRESENTATION = http://admin)
   )
 )
EXTPROC_CONNECTION_DATA.sms.sharif.edu =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
   (CONNECT_DATA =
     (SID = PLSExtProc)
     (PRESENTATION = RO)
   )
 )
please guide me how to fix this error.
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
