Good Afternoon All,
I've got a problem I'm hoping someone can help me with. First I'm
running SQL Server 2008 and have a Linked Server to Informix. Two
weeks ago I was able to setup the Linked Server successfully and wrote
a Stored Proc to pull data from the Linked Server into a table in
SQL. The stored procedure was scheduled to run twice daily and did so
until 12/6 when it has stopped running but no errors are written to
the log.
Also today I tried to test the Linked Server using sp_testlinkedserver
and it ran for about 10 minutes before I tried to cancel it locking up
SSMS. I also tried using Openrowset instead of OpenQuery and the
statement never errors out but never returns the recordset.
I have WinSQL installed and the query returns in less than a second
against the Informix DB. So I'm not sure what is going on with SQL
Server.
Anyone have any ideas?
Thanks, Jody
>> Stay informed about: Linked Server Not Working Now...