TNS-less Connection String ORACLE ODBC 10.1
533740Sep 14 2006 — edited Sep 14 2006Hello,
i was wondering if there is no working connection string to connect to an oracle DB without setting the tnsnames.ora file or DSN.
With "Microsoft ODBC for Oracle" i found this one that works:
Driver={Microsoft ODBC for Oracle}; CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=100.5.10.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OSS))); uid=323;pwd=323;
Microsoft ODBC is built on Oracle ODBC drivers ... and it is dependend on it.
So there has to be a string for ORACLE ODBC ...
I tried this one:
Driver={Oracle in OraClient10g_home2}; CONNECTSTRING=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 100.5.10.1)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = OSS))
i get => Error in protocol adapter
Does anybody have a hint?
Tnx!
(System: ADO, VB6, ORA10g Full Client,WIn XP Pro)