Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    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??

    Thanks
    Anthony

  2. #2
    Join Date
    May 2002
    Posts
    299

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

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

    http://support.microsoft.com/?id=317852
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

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