November 18, 2009 at 4:01 am
Hi
We have a linked server from SQL Server 2005 to Oracle 10.1.2 and is been working fine for almost 1 year now.
yesterday suddenly we have been facing issues and getting error message
OLE DB provider "OraOLEDB.Oracle" for linked server "ORALNK" returned message "ORA-01403: no data found".
Msg 7346, Level 16, State 2, Line 2
Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "ORALNK".
This is seriously strange.
I have enabled the AllowInProcess, as i read in some forums that it should be enabled for the provider which is being used.Still not working.
Any help will be appreciated.
November 18, 2009 at 4:20 am
http://qa.sqlservercentral.com/Forums/Topic538856-149-1.aspx#bm539530
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 18, 2009 at 8:13 am
Take SQL Server out of the picture and try and run the same query at the command line, using 'sqlplus'. Does it return data? Can you query other tables from 'sqlplus'?
I've had to switch the data source provider before, from the Oracle driver to the Microsoft OLE DB Provider for Oracle:
Server Objects -> Linked Servers -> right click properties of your linked server, Provider drop down menu
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply