By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

OLE DB Provider for ODBC and Oracle

P: n/a
Hi,

I created a linked server for MS SQL Server 2005 Express to an Oracle
database using the OLE DB Provider for ODBC. My ODBC Source uses the
Microsoft ODBC for Oracle driver.
I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
providers because those don't handle Oracle's Numeric Data Type well.
When I set this up yesterday it worked fine. However I log in today and
attempt to run sp_tables_exec against my linked server and get the
following

OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC driver for Oracle][Oracle]".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "MSDASQL"
for linked server "WHATEVER".

I can tnsping the server, and I have no trouble connecting with the
Oracle OLE DB provider

I try to set up ODBC logging but the log file is blank -- same with
attempting to set up logging for Oracle's network client. I've been
dealing with crap like this the last 4 days, something works one day,
then the next nothing (I've done nothing to change the configuration
between these outages).

Can anyone help me?

Thanks
Frustrated

Dec 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Replied to duplicate post of 22/12 !

"Crazy Cat" <da******@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hi,

I created a linked server for MS SQL Server 2005 Express to an Oracle
database using the OLE DB Provider for ODBC. My ODBC Source uses the
Microsoft ODBC for Oracle driver.
I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
providers because those don't handle Oracle's Numeric Data Type well.
When I set this up yesterday it worked fine. However I log in today and
attempt to run sp_tables_exec against my linked server and get the
following

OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC driver for Oracle][Oracle]".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "MSDASQL"
for linked server "WHATEVER".

I can tnsping the server, and I have no trouble connecting with the
Oracle OLE DB provider

I try to set up ODBC logging but the log file is blank -- same with
attempting to set up logging for Oracle's network client. I've been
dealing with crap like this the last 4 days, something works one day,
then the next nothing (I've done nothing to change the configuration
between these outages).

Can anyone help me?

Thanks
Frustrated

Dec 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.