Post reply

ODBC SQL server driver [DBNETLIB] error conecting to SQL 2000

  • June 6, 2007 at 8:27 am

    #153622

    I have an issue with a ODBC connection running a report.

    When I use name pipe the reports works fine; but when I use TCP/IP I got:

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData(CheckforData())

    The client is a Windows 2003 server R2 service pack2 - Citrix Metaframe

    Database SQL server 2000 Serv. pack 4

    Any help I will appreciate.

    ----------------------------------------------------------------

    I posted this issue yesterday; but I figured it out. Basically this error ocurrs when you install Windows 2003 Server service pack 2; since this enable a feature called " TCP/IP Offloading engine " this one cause some issues when you run heavy queries.

    Therefore I disabled that feature and the report is running ok.

    I hope this solution will helps to someone else.

    Thanks.

    Miguel

  • June 8, 2007 at 7:23 am

    #711663

    Did you try this article?

    http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/2475396BD?OpenDocument

  • June 8, 2007 at 9:23 am

    #711729

    Thanks for your email; but at the end of my email I posted the solution; the issue is with the Windows 2003 R2 service pack 2; since the service pack enable a feature called TOE ( TCP/IP offloading engine ) and this cause that error when you run heavy queries at SQL server.

    Basically we disabled that feature and everything is working fine.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply