OLE DB Provider for ODBC and Oracle

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

.

Relevant Pages

  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • Re: Samplclnt example in MDAC 2.8: My Story
    ... I was incorrect when I stated that ODBC as a whole is deprecated. ... ODBC provider for OLE DB is deprecated; ... > | compiler errors. ...
    (microsoft.public.data.oledb)
  • Re: Word 2007 mailmerge
    ... Word is trying to connect using the OLE DB provider ... it either fails because that provider is not present or because the table name is in the wrong format for the provider. ... (this is what Word generates when you try to connect manually using ODBC) ... on Vista, the default folder for Data Sources is now some kind of "search folder" that does not appear to pick up data sources recently saved in the former default folder, i.e. the user's My Data Sources folder ...
    (microsoft.public.word.vba.general)
  • Re: Linked server from SQL Server to Access db on network share?
    ... What it looks like is this: SQL can create a linked server to a file on a remote share, but you can't query against it using Query Analyzer from any system other than the one hosting SQL... ... EXEC sp_tables_ex 'OLDSQL' ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
    (microsoft.public.sqlserver.msde)
  • Re: Is there any (free!) ADO - OLE DB Provider for Lotus Notes?
    ... I know that I can use OLE DB Provider for ODBC and then use OBCD ... So....is there any OLE DB Provider for Lotus Notes??? ...
    (microsoft.public.data.ado)