473,320 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

[DBNETLIB]ConnectionRead (recv()).General network error.

Hi,
At One of our PC (Windows XP) we are using a VB Application and which
is connected to the SQL Server Remotely through VPN Setup. The
Application works fine for some forms and Fetches the records from the
database but on some of the forms either on insertion or displaying
the records from databse it shows the following error.

Error Number -2147467259
[DBNETLIB]ConnectionRead (recv()).General network error.
Check your network documentation.

Runtime Error –2147418113(8000ffff)
Connection Failure

This is happening while connecting to three Seprate PC (All are
Windows XP) which has SQL Server 2000 installed while for one PC
having SQL Server 2000 it works perfectly Fine.

I tried to compare both the SQL Server (The one which is giving errors
and the other one which is working fine) and found that they have
different DBOwner set then i changed the DBOwner to "SA" (earlier
Administrator) but that did not solve the purpose.
Both the SQL Servers (The one which is giving errors and the other one
which is working fine) are connected through Named Pipe Options set in
NetLibrary . I tried to change the option to TCP/IP but that did not
help.

Then in last I tried to Run the SQL Profiler to Capture the Error
events but Profiler is unable to Capture the Events. Even Profiler
Shows one particular SP ( SP_SqlAgent_get_perf_Counters )executed
several Times, I even tried to change the Registry for this SP and set
it to Zero but Profiler is still unable to capture the events .

Has any body any idea's that why this error is coming and why the SQL
Profiler is not able to capture these error events.

Can the size of Query (which are executing) be a problem while
connecting through VPN. Like is there any limit of in terms of Query
length which is sent to SQL Server through VPN and beyond a particular
limit it raises the error.

Any Suggestions from the any body will be highly appriciated.

Thanks in advance

Amit Kathuria
Jul 20 '05 #1
0 18659

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: stanley j Mroczek | last post by:
Every thing is on one machine, Programs and sql. Sql is up and running(can test with query analyzer). No changes where made! This was working fine. How do you track this error? What network...
2
by: SteveS | last post by:
Hello all. This problem is stumping me.... I run a page called "default.aspx". For some reason when I execute this page, I get the error below. It seems to run through the entire code behind...
7
by: stan | last post by:
I have .net 2003 and SQL 2000 setup on one system. All I have is one computer (no network). I am able to get to the internet that works. I can run SQL Query Analyzer and it works. The program was...
0
by: David Sworder | last post by:
Hi there, I am using the SQL managed provider in ADO.NET to fill a dataset with a large number of records. I periodically get an exception with the description "General Network Error" when trying...
11
by: galina betz | last post by:
Please help! Getting this error intermittently: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not...
7
by: Joe Ross | last post by:
I've been working with Microsoft support for over 3 weeks now on an intermittent General Network Error we're seeing in our production environment between our ASP.NET application and SQL Server...
3
by: Yong | last post by:
I get a general network error when I try to make asynchronously call ExecuteNonQuery on long sql statements that run in parallel. Here is the background info on what I'm trying to accomplish: I...
0
by: Yong | last post by:
I'm not getting any reply to my previous thread so I'm stating a new one. I get a General Network Error due to my SqlCommand object not having a big enough CommandTimeout to complete very long...
0
by: johnkamal | last post by:
Hi, Some times while opening a page, I am getting the following error message, Please help me to rectify the problem. Server Error in '/' Application. General network error. Check your...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.