Posted by John Bell on 12/05/68 11:35

Replied to duplicate post of 22/12 !

"Crazy Cat" <danbredy@hotmail.com> wrote in message
news:1135178623.892320.137120@o13g2000cwo.googlegroups.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
>

[Back to original message]