Code:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQL0LEDB' reported an error. The provider did not give any information about the error.
[\code]
Am getting this error when trying to access a linked server. I have looked it up on MS.com and google. Seems like its not totally unprecendented, but I can see no solution out there other than a suggestion to uninstall SQLServer etc on the linked box. This is not possible in this case (production machine).
Anyone had this problem ? I should add that the issue appeared suddenly, after weeks of the server link working ok.
I can still see the tables in Enterprise Manager (under Security -> Linked Servers) and have tried dropping and re-adding the server on numerous occasions, but no joy. I can do selects from a Query Analyser session that is opened from the linked box itself in Enterprise Manager, but get the above error trying distributed queries from a QA session opened from the Server I'm working from....
Any help welcome...
:(
------
Dublin, Ireland.