Activity Stream
93,593 MEMBERS
28 ONLINE
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
Results 1 to 3 of 3
  1.    Tweet this post   Share This Post On Facebook Share This Post On Google+
    #1

    Help ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure

    hi to all i have win xp sp3 profesional as i have installed MS SQL Server 2000 registerd ,When I open design table in 2000 Enterprise Manager and clicked on Index properties tab ,I am getting following ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure

    [Login or Register to remove this advertisement]

    Please help me.

    thanks in advance
    fareedi Reviewed by fareedi on . ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure hi to all i have win xp sp3 profesional as i have installed MS SQL Server 2000 registerd ,When I open design table in 2000 Enterprise Manager and clicked on Index properties tab ,I am getting following ODBC error: Communication link failure Please help me. thanks in advance Rating: 5

  2.   Advertisements

  3.    Tweet this post   Share This Post On Facebook Share This Post On Google+
    #2
    Special Member
    Senior Poster
    Mobile_Guru's Avatar
    ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
    1)Check if the network connection is primestable
    2)Check the integrity of your database. An integrity fault due corruption can cause an aborted connection.

    More things to check.
    3) The server is momentarely down

  4. The Following 1 Users Say Thank You to Mobile_Guru For This Useful Post:
    [ Click to Expand ]

    fareedi (6th May 2014)

  5.    Tweet this post   Share This Post On Facebook Share This Post On Google+
    #3
    Special Member
    Senior Poster
    Mobile_Guru's Avatar
    ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure

    Info Communication link failure

    "General Network error," "Communication link failure," or "A transport-level error" message when an application connects to SQL Server


    Scalable Network Pack


    The SNP is a set of high-speed networking features that were introduced as part of Windows Server 2003 Service Pack 2 (SP2). These features also were included as part of Windows Server 2008 and later versions.

    Note Because these features are part of the base TCP/IP stack in Windows Server 2008 and later versions, they are no longer known as Scalable Networking Pack features.

    The important SNP features relevant to this article are as follows:
    • TCP Chimney Offload This feature transfers TCP/IP protocol processing from the CPU to a network adapter during network data transfer.
    • Receive Side Scaling This feature enables the network load from a network adapter to be distributed across multiple CPUs in a multiprocessor computer.
    • NetDMA This feature provides services for offloading the memory copy operation that is performed by the networking subsystem to a dedicated direct memory access (DMA) engine when receiving network packets.

    Error messages when an application connects to SQL Server

    You may receive one or more of the following error messages when your network hardware is incompatible with SNP features.

    Note You may receive one or more of these error messages when one of the following conditions is true:
    • The computer on which the hardware is installed hosts the instance of SQL Server.
    • An application connects to the instance of SQL Server by using TCP/IP.

    Error message 1

    [Microsoft][ODBC SQL Server Driver][DBNETLIB] General Network error. Check your network documentation



    Error message 2

    ERROR [08S01] [Microsoft][SQL Native Client]Communication link failure



    Error message 3

    System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)




    You may also receive one of these error messages when the network load on SQL Server is high. For example, you may receive one of these error messages when you replicate databases in SQL Server. Or, you may receive one of these error messages when a multiple-user application accesses databases in SQL Server.

    Verify the current configuration

    To display the current TCP global parameters, at a command prompt, type the following command, and then press Enter:

    Netsh int tcp show global


    The output of this command resembles the following:







    To display the network adapters that have the TCP Chimney Offload feature enabled, at a command prompt, type the following command, and then press Enter:

    Netsh int tcp show chimneystats


    The output of this command resembles the following:







    Recommendations for using SNP or other network offload features in SQL Server environments

    If you receive intermittent network errors as described in this section, refer to the following tables for guidance on how to realize the maximum benefits when you use the networking performance improvement features in SQL Server environments.

    Table 1: Common guidance for all versions of Windows Server



    Operating-system version Recommendations
    All versions of Windows starting with Windows Server 2003 Service Pack 2
    1. Ask the hardware vendor whether the following updates are available:
      • The latest basic input/output system (BIOS) update for the server
      • The latest firmware update for the network adapter
      • The latest driver update for the network adapter

    2. Update antivirus software to the latest versions or engines and definitions.


    Table 2: Windows Server version-specific guidance.



    Operating-system version Recommendations
    Windows Server 2003 Service Pack 2 We recommend that you disable SNP features by installing the hotfix that is documented in the following article in the Microsoft Knowledge Base:
    [Only Registered and Activated users can see Content.
    Click Here To Register..
    ]
    Update to turn off SNP features for Windows Server 2003 and Windows SBS 2003
    If network performance is very important, we recommend that you consider migrating to a later version of Windows Server that is included with the next generation of the TCP/IP stack. If you cannot immediately upgrade to a newer version but have to maximize network performance, we recommend that you follow these steps on all the affected servers:
    1. Disable SNP as described in the following article in the Microsoft Knowledge Base:

      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      Update to turn off SNP features for Windows Server 2003 and Windows SBS 2003
    2. Install the hotfix that is described in the following article in the Microsoft Knowledge Base: [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      A Scalable Networking Pack (SNP) hotfix rollup package is available for Windows Server 2003
    3. Enable the Receive feature. By using Regedit.exe

    4. HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
      EnableRSS=1 (Dword)
    Windows Server 2008
    1. Install Windows Server 2008 Service Pack 2 (SP2). For more information about Windows Server 2008 SP2, go to the following Microsoft website:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]

    2. Install the hotfix that is described in the following article in the Microsoft Knowledge Base:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      Description of a reliability update for the TCP Chimney Offload feature in Windows Server 2008 and in Windows Vista
    3. Install the hotfix that is described in the following article in the Microsoft Knowledge Base:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      Some TCP/IP parameters in the registry are changed to incorrect values when you use the netsh command to change TCP/IP global parameters on a computer that is running Windows Server 2008 or Windows Vista
    4. Re-enable Receive Side Scaling (RSS) in the operating system and network adapters. For information about how to re-enable RSS, click the following article number to view the article in the Microsoft Knowledge Base:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      Some TCP/IP parameters in the registry are changed to incorrect values when you use the netsh command to change TCP/IP global parameters on a computer that is running Windows Server 2008 or Windows Vista
      Note By default, the TCPChimney feature is disabled in Windows Server 2008.
    Windows 7 and Windows Server 2008 R2
    1. Install Windows 7 and Windows Server 2008 R2 Service Pack 1 (SP1). For information about to download and install Windows 7 and Windows Server 2008 R2 SP1, go to the following Microsoft website:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]

    2. Install the hotfix that is described in the following article in the Microsoft Knowledge Base:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      An enterprise hotfix rollup is available for Windows 7 SP1 and Windows Server 2008 R2 SP1
      Note If Windows 7 or Windows Server 2008 R2 SP1 is not installed, install the hotfixes that are described in the following articles in the Microsoft Knowledge Base:
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      RSS network throughput performance decreases on Windows Server 2008 R2-based computers that have more than 32 processors
      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      RSS network throughput performance decreases on Windows Server 2008 R2-based computers that have more than 32 processors
      If the TCP Chimney Offload feature is enabled, install the hotfix that is described in the following article in the Microsoft Knowledge Base:

      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      The SACK option is always set to "true" even if network adapter does not support SACK for offloaded connections in Windows 7 or in Windows Server 2008 R2
    3. If it is necessary, re-enable RSS in the operating system and network adapters. For information about how to re-enable RSS, click the following article number to view the article in the Microsoft Knowledge Base:

      [Only Registered and Activated users can see Content.
      Click Here To Register..
      ]
      Some TCP/IP parameters in the registry are changed to incorrect values when you use the netsh command to change TCP/IP global parameters on a computer that is running Windows Server 2008 or Windows Vista

      Note By default, the TCP Chimney Offload feature is set to Auto. This means that the chimney does not offload all connections. Instead, it selectively offloads the connections that meet the following criteria:
      • The connection is established through a 10 gigabits per second (Gbps) Ethernet adapter.
      • The mean round-trip link latency is less than 20 milliseconds.
      • At least 130 kilobytes (KB) of data were exchanged over the connection.



      Note
      By default, the TCP Chimney Offload feature is disabled in virtualized clients.
    Window 8 and Windows Server 2012 Currently, there are no known issues. We recommend that you use the default configuration for high-speed networking features.

    Note By default, the TCP Chimney Offload feature is disabled in Windows Server 2012.


    Turn off SNP/high-speed networking features

    We do not recommend that you turn off SNP features on newer versions of Windows Server. However, you may have to disable SNP on your Windows Server-based computer as a troubleshooting step or because you lack hardware support for all the RSS features. For more information, see the following table:



    Windows Server version More information
    Windows Server 2003 See the following article in the Microsoft Knowledge Base: [Only Registered and Activated users can see Content.
    Click Here To Register..
    ]
    Update to turn off SNP features for Windows Server 2003 and Windows SBS 2003
    Windows Server 2008 See the following article in the Microsoft Knowledge Base: [Only Registered and Activated users can see Content.
    Click Here To Register..
    ]
    Information about the TCP Chimney Offload, Receive Side Scaling, and Network Direct Memory Access features in Windows Server 2008
    Windows Server 2008 R2 Do not disable
    Windows Server 2012 Do not disable


    Note We recommend that you use the default configuration for the high-speed networking features in Windows Server 2008 R2 and Windows Server 2012 environments. However, you can disable the TCP Chimney Offload feature if you know that you do not want to use it or if you want to keep settings consistent across a mix of different operating systems in your environment.

  6. The Following 2 Users Say Thank You to Mobile_Guru For This Useful Post:
    [ Click to Expand ]

    basflt (6th May 2014),fareedi (6th May 2014)

Thread Information

Users Browsing this Thread

There Are Currently 1 Users Browsing This Thread. (0 Members and 1 Guests)

Similar Threads

  1. [DISCUSSION] Steve Ballmer admits: RT Surface is a failure
    By IdFixPDA in forum General Discussions
    Replies: 1
    Last Post: 27th December 2013, 04:06 AM
  2. [THEME] System failure by Lao Stia Free by NajThashi
    By kool6raaz in forum Symbian S^3 Theme / Wallpaper /Skin/ Icon /Fonts
    Replies: 0
    Last Post: 5th August 2012, 04:02 PM
  3. FRUIT Link Link (MATCH) v1.01 Android
    By free59 in forum Android OS Games
    Replies: 0
    Last Post: 29th February 2012, 03:44 PM
  4. [Qt] Microsoft Apps Link, One Note & Office Symbian Belle
    By Google in forum Symbian OS^3 Applications
    Replies: 1
    Last Post: 1st February 2012, 01:17 AM
  5. [SIS] Microsoft Corporation Microsoft Communicator v2.1.369 S^3 SymbianOS9.4 Signed
    By AshuGite in forum Symbian OS^3 Applications
    Replies: 2
    Last Post: 26th July 2011, 03:26 PM

Tags for this Thread

BE SOCIAL
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure