[DBNETLIB] General Network Error - (I Have Included The Event Log Dump.)
Sep 6, 2006
I have a MS MSDE 2000 database that is serving 3 database clients. Intermittently, randomly, and more important daily, my clients receive a "SQL Database Connection Error", and they are kicked out of the database. This appears to be correlated when they are writing/retrieving a record.
MS MSDE then writes the following error in it's event log.
--------------------------------
Source: SORules.Gateway.LogErrors
Process ID: 2328
Database connection lost
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
(Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 08S01)
(NativeError: 11)
No Help file available
OpenRsRead
System.Runtime.InteropServices.COMException (0x80004005): [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
Stack trace:
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
--------------------------------
Any help, suggestions, or thoughts would be greatly appreciated. This is for a small business line of business application that is critical for everyday business operations. These problems have resulted in lost work, short tempers, and a just frank frustration.
I am just getting started with MS SQL technologies and really need some quality help.
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Hi While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears. Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
I have a friend at another company that is getting this error:
03/07/2007 16:03:49 Version 21.00.69 - UID - xxx - Error -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
I have checked around and found two potential fixes for this problem. The first one describes this as a problem specific to the Named Pipes protocol. The fix is listed as available from this site:
The second fix is listed as making an additional entry to the registry like this:
The problem arises on a busy SQL system and some requests will randomly seem to be dropped with a General Network Error.
To fix: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServic esTcpipParameters Add a new DWORD key SynAttackProtect with value of 0. Restart server. Can someone tell me if either or both of these approaches is correct?
I have application desinged using VB.Net and sql server 2005. Its been deployed at remote site which is connected to my database server using VPN.
There are 2 machine at the remote site. One machine is working perfectly with all the reports and forms working. second machine is having problem runing one report. Reports is based on View which around 8 tables joined.
It shows the following eror
failed to openrowset Microsoft OLD DB provider for sql server DBNETLIB connectionread(recv()). General Network Error. Check your network doucmentation.
Hi, in our environment - Windows XP - SQL Server Express 2005 - Internet connection via TCP/IP protocol
The described network error occurs, when we unplug the network cable: [DBNETLIB][ConnectionWrite (send()).] General network error.
The affected database resides on the locally installed SQLExpress, it doesn't use any network connections. The error doesn't occur immediately, in most cases there are up to 30 seconds where data can be (correctly!) written to the recordset, but after that timeout the connetion is broken.
We already tried out the described workarounds: - disable named pipes protocol - set SynAttackProtect=0 in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters
The error doesn't occur with MSDE (SQL 2000) or under Vista.
since over a week I've been looking to find out the reason for two error messages I get from our users and servers, unfortunately without success up to now.
I really hope you can help me.
We are using Win 2k servers with active directory and SQL Server 2000, clients are all Win XP with SP2. Versions of access are 2002 & 2003. The errors are userspecific and occur in both versions. The SQL-Servers are accessed with an adp-file in 2002-format.
We have one usergroup which is member of specially many groups. This affects the size of their windows access token which becomes constantly larger. In order to enable those users to still access their mailboxes on our Exchange servers, the DWORD entry "MaxTokenSize" with the decimal value "65535" was made to the newly created key "Parameters" of their registry branch "HKLMSYSTEMCurrentControlSetControlLsaKerberos ".
Since then those users can not access any of our SQL Servers using the windows authentification. One of them gets the error "[DBNETLIB][ConnectionRead(recv().] General network error. Check your network documentation.", the others the error "Check connection: Failed: Cannot generate SSPI context".
In case of resetting the registry entries (by deleting them), the one user receives the same error message as the rest while it doesn't make any difference to those (but at least they can't connect to their mailboxes).
After having researched the web, I realised in one of the SQL-Servers logfiles the entry "Invalid buffer received from client.." which lead me to start to believe it could have to do something with the kerberos encryption in the first place. Therefore I asked if changes to the tokensize had been made. I applied the change with "EXEC sp_configure 'network packet size', 65535 RECONFIGURE" on our testsystem and "EXEC sp_configure" confirms that the value is run.
Consequence: The entry in the SQL Server log doesn't appear any longer, but the users still receive their error messages.
We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection.
[DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation.
Native Error: 11
SQL State: HY018
msado15.dll version 2.82.3959 is on this server.
On other servers running Windows 2003 Enterprise Edition sp1 the error on the ADO command object is normal with.
Timeout expired
Native Error: 0
SQL State: HYT00
msado15.dll version 2.82.1830 is on this server.
The SQL server they are talking to is on the other side of a firewall. It is SQL 2005 sp2 running on Windows 2000 sp4.
I have also tested this on a Windows 2003 sp2 server that doesn't have to cross a firewall and get the correct Timeout error. It also has the same version of msado15.dll as problem server.
The application is a collection of VB6 Components that are running in COM+ applications. I have isolated the test application to our one SQL interface component and have build a test vbs that can reproduce this on demand. The VB6 Components were not modified in any way for this change and have been working fine for many years prior to this.
All other aspects of our batch processing works as expected. Transactions are working fine. As long as the SQL doesn't timeout everything is normal. DTCPing was used to ensure both servers have correct ports open to allow DTC traffic. Checked the SynAttackProtect setting on SQL and this is not an issue since other clients have no problems.
One point I would like to add is that this new server was initially setup with a temporary server name and then was changed to use the name of the original server on move day. Don't know if this has any impact or not.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application. --------------------------------------------------------------------------------
General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281: Line 282: myConnection.Open() Line 283: myCommand.ExecuteNonQuery() Line 284: myConnection.Close() Line 285: End Sub
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows: General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException: General network error. Check your network documentation.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
Hello. I'm running into a rather intermittent problem when a search query is run on an ASP.Net web application. The error is 'General Network Error' Check your Network Documentation... As I said, it doesn't happen everytime which leads me to beleive that there is a problem with the database connection There's probably no more than 50-60 max users hitting the app at any one time. Anybody familiar with this?
hi guys i am developing my application on framework 1.1 on asp .net i am trying to connect to sql server 2005 but it gives me error like general network error check your network documentation.
does any one know how to solve this error then pl reply fast
Please help!Getting this error intermittently:System.Data.SqlClient.SqlException: Timeout expired. The timeout periodelapsed prior to completion of the operation or the server is notresponding. at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() After getting a fair number of these errors I get this one also:System.Data.SqlClient.SqlException: General network error. Check yournetwork documentation. at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() SQL connection pooling is turned off. All sql parameters passed to thestored procedure and all the data types are correct.*** Sent via Developersdex http://www.developersdex.com ***
I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using aTCP/IP client connection.I get this error when attempting to restore a database.[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(WrapperRead()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.Check your network documentation.Does anybody know how to resolve this issue?Thanks
Hi , can anyone explain what is general network error. Im facing this error quite frequently during DTS uploading of data. When ever DTS is running this error is generated and the specific package fails to load the data and continues loading data for other packages and certainly interupts the loading process. This error doesnt seems to occur on 1 package but on different.
I have a problem with my application.when i try to run it to a network pc, show me this message "Network general error". But if i run it to simple pc everything ok.
Database is local. SQL Express agent running locally.Also all protocols for sql server is enebled.
An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.".
The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
I'm using Native OLE DBSQL Native Client provider to get data from SQL Server 2000 database into SQL Server 2005 database using SSIS.
The problem is I get this error:
An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.".
The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
When trying to view a web page from my local web server with a database that is connected to a remote sql 7 db I get the following:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
/sql7Test/ASP Page2.asp, line 30
If I upload the page to the web host and view, I can see the page fine. I am using VI6 and can see the data through the data tools, but when I view the project web page, I get the above error.
Hello everyone, this post will be a bit lengthy, so please bear with me. I've been programming asp.net for abou 2 years. I'm not a master by any means, and I do things like I learn from books. Here is my standard way of connection to my mssql database (which is on the same server as my site, so I just use "localhost") Dim objConnection As New SqlConnection(Application("dbstring")) Dim strSQL As String = "SELECT * FROM myTable WHERE this='that'" Dim objCommand As New SqlCommand(strSQL, objConnection) Dim objDataReader As SqlDataReader
Do While objDataReader.Read() = True 'Do what I need to do with the data Loop
objDataReader.Close() objConnection.Close()
objConnection.Dispose()Here's my issue. Our website gets this error 2-4 and as many as 6 or 7 times a day: General network error. Check your network documentation.Line ###: objConnection.Open()I use the method I wrote above for getting data on almost every page in the site. Its a HUGE site, but I've made sure that I close all my connections. This is my global connection string: Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) Application("dbstring") = "Server=WWW1;database=###;uid=#####;password=#####;Connect Timeout=300;Connection Reset=False;Pooling=False;Max Pool Size=75000;" End Sub Here's my web.config file:<configuration> <system.web> <customErrors mode="Off"/> </system.web></configuration>... This server has only one website running on it, its a dedicated server. Is there something in my code causing this error to happen so much? We have to restart the sql server everytime this error happens for it to go away. Its very disruptive to the website.
I am getting "General network error. Check your documentation." I am using .net 1.1 to connect sql server 2005 database at remote place. .net code is running on windows xp and database(Dev database) is running on windows 2003 server. below is my code.
conn = new SqlConnection("Persist Security Info=False; User ID=xxx; Password=pwd; database=WBWT; server=machinename; Connect Timeout=300; Max Pool Size=10"); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure ; cmd.CommandText = "TestForCollation"; SqlParameter param1 = new SqlParameter("@MESSAGE",SqlDbType.NVarChar, 100); param1.Value= "Dhanaji"; param1.Direction = ParameterDirection.Input; cmd.Parameters.Add( param1 ); SqlParameter param2 = new SqlParameter("@CATEGORY",SqlDbType.Char, 10); param1.Value= "Patil"; param1.Direction = ParameterDirection.Input; cmd.Parameters.Add( param2 ); adapter = new SqlDataAdapter((SqlCommand)cmd); adapter.Fill(ds); // here it throws exception
When i use VARCHAR data type or Output parameter in stored procedure it gives this error. For the stored procedure which has not any parameter or only input int parameter is executed sucessfully, Same SP is excuted sucessfully on local machine. I need urgent help
Also same code works on another database at remote place(QA database)
We have a .net 1.1 application that gets this both with MSDE and SSE but more with SSE.
It randomly crashes with this error on laptops where they have SSE or MSDE installed on the local computer. They're being referenced by the machineNameInstance because (Local)Instance had bugs in the past with network connections disappearing and us getting this error. Now we're getting this, especially with Intel Wireless Cards on a random but consistant basis.
Under SSE we've had to turn on tcp/ip to make our app run, which tells me that something is preventing it from using shared memory access, which I suspect is that we're not using (Local)Instance, so I tried switching it, and no dice, same problem.
Is anyone else getting this? It's driving us nuts!!!! (and pissing off customers)
This is regarding the intermittent failure of communication between the application server and database server in one of our customer environment. Application error as well as SQL error log shows "General Network Error","Communication Link Failure". Please find below the server configuration
Application Server OS: Win 2003 server + Service Pack1, Standard Edition Database Server OS: Win 2003 server + Service Pack1, MS SQL Server 2000 + SP4
We have checked the Client/Server Network utility associated with SQL Server and found TCP/IP protocol is used in communication neither than Named Pipes. DSN is used. We have also followed and implemented as per one KB article which mentioned Win 2003 server's feature of preventing Denial of Service attacks (Chance may be there to prevent the valid login packets).We made the registry changes and disabled this feature. A scheduled job which updates the database happens every morning. Also backup was done using a backup utility which needs the exclusive access to DB. So we have asked the customer to use enterprise manager for back up the DB instead of using the other utility to backup. If any one have experienced the same issue, please let me know.
First of all, sorry for the cross post but i need a quick answer on this.
I am executing a CLR Stored Procedure from a Windows Mobile device and regularly get a general network error.
The stored procedure cycles through up to 70 tables, checking for any records between two dates. The LastUpdate field is in each one of the 70 tables and is indexed.
The mobile device regularly reports general network error, which is due to a timeout. Command timeout is now set to 10 minutes but the timeout still occurs.
The stored procedure appears to get stuck on a particular table. If I rebuild the index on this table, it will get past it but then get stuck on the next table.
I set up a maintenance plan to run every 5 minutes (extreme, I know!) but the indices would appear to corrupt (without any activity on the table) in less than this interval.
However, running the exact same query from SQL Server Management Studio works correctly every time and usually within 10 seconds.
I€™m sure that it has something to do with the indices but cannot seem to resolve the issue. It€™s even more confusing how only the mobile device is affected!
We have a VB6 app, with SQL2005 database, SQLOLEDB driver
We have it installed at many clients and normally works fine.
We've migrated one client from SQL2000 to SQL2005 and had to move the database to a new machine.
It's now running SQLExpress sp1, on a Win XP sp2 machine
The clients now frequently get either
a) SQL timeouts or b) Runtime Error€™2147467259 (80004005) [DBNETLIB][Connection Read(recv()).]General network error. Check your network document Errors I suspect it is something to do with connections not be released (even though we explicitely free them in the app). Where do I look ? Thanks Bruce
We have a SQL 2005 clustered server (Microsoft Cluster Services) that is queried from 4 IIS6 Windows Server 2003 frontends. Each frontend runs both classic ASP apps connection with SQL Server ODBC and .NET2 apps connecting with System.Data.SqlClient. Ocassionaly we get a string of errors/timeouts opening a connection lasting maybe 2 minutes.
One the classic ASP apps we log one of these two errors:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation
or
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver]Timeout expired on the ADODB.Connection.Open On the .NET2 apps we log Message Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
StackTrace at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo)
