Strange Linked server issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » Strange Linked server issue

Strange Linked server issue

Rate Topic

Display Mode

Topic Options

Author

Message

l.madhupradeep

Posted Thursday, May 10, 2012 4:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 19, 2013 11:19 AM
Points: 2, Visits: 129

Hi All,

I am having problem with pulling data from Linked Server that I have created using "Oracle Oledb Provider". I am able to created Linked server and tested the connection successfully. But I am unable select the data from table when running SELECT statement. I have used both four part naming and OPENQUERY method. I am getting same error in both cases.

Here is the error I am getting.

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server "IMPRX_D" reported an error. The provider did not give any information about the error.

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "IMPRX_D".

Environment:

SQL Server 2005 SP3 32-Bit

Windows 2008 R2 64 Bit

Oracle 11g Client 64 bit

Please let me know if I missed to provide any details.

Thanks

Madhu Pradeep

Post #1298249

l.madhupradeep

Posted Monday, May 14, 2012 8:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 19, 2013 11:19 AM
Points: 2, Visits: 129

All,

I have fixed it using "Allow in Process" Setting of "Oracle.oledb" provider.

1. Unchecked "Allow In Process" setting for provider.
2. Created Linked Server.
3. Checked "Allow In process" setting for provider.

I could n't created Linked server when above setting is enabled, So I had to uncheck the option and create the linked server.

But I don't really understand why.

If anyone has same experience and know the reason, Please post here.

Thanks
Madhu Pradeep

Post #1299584

« Prev Topic | Next Topic »

Permissions