Oracle 9i linked server

Hi, I'm using the Oracle Ole db provider and receive the following error:
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Exec
ute returned 0x80040155].
Any ideas?
TiAFor all SQL statements? Or a specific query?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Pacific" <anonymous@.discussions.microsoft.com> wrote in message
news:F1B5E60E-BE89-448E-8FCB-01C9C0C70FCB@.microsoft.com...
> Hi, I'm using the Oracle Ole db provider and receive the following error:
> Server: Msg 7320, Level 16, State 2, Line 1
> Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
> OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle'
ICommandText::Execute returned 0x80040155].
> Any ideas?
> TiA|||for all statements

Oracle 9i linked server

Hi, I'm using the Oracle Ole db provider and receive the following error:
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute returned 0x80040155].
Any ideas?
TiA
For all SQL statements? Or a specific query?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Pacific" <anonymous@.discussions.microsoft.com> wrote in message
news:F1B5E60E-BE89-448E-8FCB-01C9C0C70FCB@.microsoft.com...
> Hi, I'm using the Oracle Ole db provider and receive the following error:
> Server: Msg 7320, Level 16, State 2, Line 1
> Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
> OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle'
ICommandText::Execute returned 0x80040155].
> Any ideas?
> TiA
|||for all statements