Hi John,

You should be able to do it DSN-less. The connection string should be:

"Provider=msdaora;Data Source=MyOracleDB;" & _
"User Id=myUsername;Password=myPassword"

I don't know if this slightly-different version will work for you or not.
Info from:

http://www.able-consulting.com/MDAC/...romMicr osoft

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


John wrote:
I am having trouble defining an OLEDB connection string to
an Oracle database. I have no problem using an ODBC
connection.

Works (ODBC)
obj.Connection = "ODBC;DRIVER={Microsoft ODBC for
Oracle};SERVER=IFAS;UID=scott;PWD=tiger"

Doesn't work (OLEDB)
obj.Connection = "OLEDB; Provider=MSDAORA; Data
Source=ifas; User ID=scott; Password=tiger;"

Does a DSN need to be created for OLEDB connections? What
am I missing? TIA...

John