Hi everyone,

How can I specify a connection string for an Oracle database without a DSN. I want to use the Oracle driver. However, I cannot figure out how to specify it.

I know I can specify it to use the Microsoft driver as:
Driver={Microsoft ODBC for Oracle}; Server=server.db; Uid=name; Pwd=pass;

However, my stored procedures do not work with this driver. I would like to use the Oracle driver. What is the driver connection string for using it?

Thanks,
Pankaj

Try This

' Oracle Provider
   con1.Open "PROVIDER=MSDAORA;" & _
             "DATA SOURCE=MyOracleServer;" & _
             "USER ID=demo;PASSWORD=demo;"


Om Prakash

try this

Conn.Open "Provider=OraOLEDB.Oracle;Data Source=MyOraDB;User Id=demo;Password=demo"