Hi all, I am a newbie to SQL Server. I have SQL Server 2008 R2 installed on a server machine and a linked server setup to an AS400 database using a IBMDASQL OLEDB Provider.
I was able to run queries against the AS400 database via the linked server using the four part query approach "Linkedserver"."Database"."Schema"."Table" till recently. For example
All of a sudden when my queries started to fail throwing of an error about the provider.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "IBMDASQL" for linked server "AS400" 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 "IBMDASQL" for linked server "AS400".
The strange part is that when I run the same select statement in ssms on my client machine connected to the same server instead of directly in the ssms on the server machine, the query works fine and gets me the data from the AS400.
SSMS on both machines is sql server 2008 r2.
I am wondering what settings in my SSMS on the server machine that are different than the one on my client thats causing the error.
Any help would be appreciated..
If I can answer a question then anyone can answer it..trying to reverse the logic..