General Network Error Sql 2000
Contents |
360 games PC games communication link failure sql Windows games Windows phone games Entertainment All Entertainment
Microsoft Sql Server Native Client 10.0 Communication Link Failure
Movies & TV Music Business & Education Business Students & educators dbnetlib connectionwrite (send()). general network error. check your network documentation Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet dbnetlib connectionread (recv()). general network error. check your network documentation Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
08s01 Microsoft Odbc Sql Server Driver Communication Link Failure
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site error [08s01] [microsoft][sql native client]communication link failure About Us Learn more about Stack Overflow the company Business Learn more about communication link failure sql server 2012 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
General Network Error Check Your Documentation
the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up General network error after https://support.microsoft.com/en-us/kb/942861 a night of inactivity up vote 3 down vote favorite 1 For some time now our flagship application has been having mysterious errors. The error message is the generic [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation. This is reliably reproduced by leaving the app open for the night and resuming work in the morning. Since it's a backend server app this is a normal http://stackoverflow.com/questions/3211625/general-network-error-after-a-night-of-inactivity scenario. The funny thing is - we've migrated from SQL Server 7 to 2000 to 2008 and the issue is present on all of them. But what seems to matter is the OS on which we run the app. On WinXP it works fine, on Vista/7 it fails. So the problem is at the client end. The results of Google on the error message cover a very wide spectrum of different causes (since this is a very generic error) and none of the scenarios found there are similar to ours. So perhaps someone around here will know what the problem is in our case? sql-server general-network-error share|improve this question asked Jul 9 '10 at 10:10 Vilx- 49.8k57194330 Does your app keep a single SQL connection open for the lifetime of the app? –Chris Bednarski Jul 9 '10 at 10:34 @Chris Bednarski - I think so, I'm not familiar with that part. –Vilx- Jul 9 '10 at 11:22 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote You should be able to reproduce this error condition on demand by: 1. Opening a database connection (in your
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/1857875/dbnetlibconnectionopen-preloginhandshake-general-network-error-connect Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack http://www.sql-server-performance.com/forum/threads/microsoft-sql-server-login-error-help-needed.9376/ Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error - connecting to SQL communication link database in VB script up vote 1 down vote favorite I have a VB script which connects to a local SQL database to retrieve a value. The exact same script runs on about 100 servers, but a few of the servers produce this error: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation Here is the code that runs: Function GetPrimaryServerID On Error Resume Next Set objConnection = communication link failure CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") objConnection.Open "Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=xxx;User ID=xxx;Password=xxx" sqlquery = "SELECT ServerID FROM tblSettings" objRecordSet.Open sqlquery,objConnection objRecordSet.MoveFirst GetPrimaryServerID = objRecordSet("ServerID") objRecordSet.Close objConnection.Close End Function The error occurs on the 5th line when trying to open the connection string. I'm confused as to why this script is working on nearly all servers and failing on only a handful. The database that they connect to is identical on every server in terms of structure, its only the data that changes. sql database vbscript ado share|improve this question asked Dec 7 '09 at 4:50 VBscripter 43237 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted Fixed the problem by doing the following: Opened SQL Server Configuration Manager and went to Protocols for MSSQLSERVER -> TCP/IP. In the 'IP Addresses' tab, I noticed that IP2 which has address of 127.0.0.1 was active but not enabled. Changed to enabled and restarted SQL services. My VB script now successfully opens the connection to 127.0.0.1. share|improve this answer answered Dec 9 '09 at 5:32 VBscripter 43237 add a comment| up vote 0 down vote It could fail if the database is not configured to listen to TCP/IP tr
Server Login Error : help needed Discussion in 'General DBA Questions' started by starsql, Apr 17, 2007. starsql New Member Hi there, We are getting the following error whenever anyone is trying to connect to the database. --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). Connection failed: SQLState: '08S01' SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation. --------------------------- OK --------------------------- Please help me any inputs about the resolution of the error. Thanks in advance. starsql, Apr 17, 2007 #2 satya Moderator See whether SQL Server services are started or not. Check whether that user has got relevant access privleges on the server. Ensure the server alias has been defined properly. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind. satya, Apr 17, 2007 #2 Roji. P. Thomas New Member What version/SP you are using? Do you see any error in the Error Log? Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com Roji. P. Thomas, Apr 17, 2007 #2 MohammedU New Member "General network error. Check your network " is related network connectivity issue... Are you connecting locally or from some other machine/server? If you are connecting from other server/machine... First try to ping the sql server Try connecting using IP address ... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy. MohammedU, Apr 17, 2007 #2 ghemant Moderator You may refer below Kb(s) too http://support.microsoft.com/kb/827452 http://support.microsoft.com/kb/867581 Hemantgiri S. Goswami MS SQL Server MVP ------------------------- "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com ghemant, Apr 17, 2007 #2 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forum