Hi,

I'm having a problem with connecting to a version 9 Oracle database
with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
Oracle 10 client. Basically when I attempt to connect to a linked
server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
the following error - Msg 7303, Level 16, State 1 Cannot initialize the
data source object of OLE DB provider "MSDAORA" for linked server
"MSORACLE".

In attempting to get more info on the problem I discovered that
apparently my Oracle client is not logging any errors. I went into the
Oracle Net Manager and set the trace level to Admin and left all the
other parameters blank (assuming that it would just write to the
defaults), but no files are produced (sqlnet.trc or sqlnet.log).

Am I missing something here?

Thanks