Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Question Unanswered: ConnectionCheckForData((null)())??

    Hi all,

    I have 2 servers - Financial and Trilogy. Trilogy is a linked server on the Financial Database. It uses MSDASQL to link it. Now I have a insert trigger on one of the tables on the financial Database that inserts data to a table that resides on the trilogy database. A few days ago it was working fine. Any inserts into the financial table would insert data into the trilogy table, however now I get the following error when I try to an insert into the financial table.....

    Changed Language setting to Us_English
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData((null)()).
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General Network Error. Check your Network Documentation.

    The only thing that has been done within these few days was a reboot of the trilogy server.

    Also when I remove this trigger and do an insert into the financial table it works fine, so I unsure whether this error occurs due to ODBC or MSDTC?? Can anyone help with this?? And what causes this error and how do I go about fixing it??


  2. #2
    Join Date
    May 2002

    Re: ConnectionCheckForData((null)())??

    This sounds like a known issue. Please see article for info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts