6th May 2014, 03:41 AM #1OPJoin Date : Jun 2013Location : pakistanMobile : nokia c500Posts : 31Thanks: 8
- Thanked 8 Times in 8 PostsRep Power : 15Reputation : (10)
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 advancefareedi 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
6th May 2014, 02:03 PM #2Special Member
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
6th May 2014, 02:06 PM #3Special Member
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
- 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
- Update antivirus software to the latest versions or engines and definitions.
Table 2: Windows Server version-specific guidance.
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:
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.
Users Browsing this Thread
There Are Currently 1 Users Browsing This Thread. (0 Members and 1 Guests)
[DISCUSSION] Steve Ballmer admits: RT Surface is a failureBy IdFixPDA in forum General DiscussionsReplies: 1Last Post: 27th December 2013, 04:06 AM
By kool6raaz in forum Symbian S^3 Theme / Wallpaper /Skin/ Icon /FontsReplies: 0Last Post: 5th August 2012, 04:02 PM
By free59 in forum Android OS GamesReplies: 0Last Post: 29th February 2012, 03:44 PM
By Google in forum Symbian OS^3 ApplicationsReplies: 1Last Post: 1st February 2012, 01:17 AM
By AshuGite in forum Symbian OS^3 ApplicationsReplies: 2Last Post: 26th July 2011, 03:26 PM