[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error

We have built an application (VB 6 with a SQL 2000 backend database)
in-house and from time to time, we get the dbnetlib error message. This erro
r
message seems to happen when the machine is just idle and is driving me nuts
.
The error message doesnt seem to have the issue while the user is actively
using the application. Could this problem have something to do with
connection pooling? If anyone has any ideas, it would be much appreciated.
Thanks in advance!
Mike HartmanWe have seen this from time-to-time. It seems that the connection "ages out"
after a long period of dormancy. The solution I use is to occasionally poll
the server to make sure it knows that the application is still alive. I
don't think it's a connection pooling issue. It looks like the transport
layer is being closed at the server end (in my case).
USE <initial catalog>
is enough to do the job.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:772A11BE-EF7D-4088-8654-9C29D15F1FCC@.microsoft.com...
> We have built an application (VB 6 with a SQL 2000 backend database)
> in-house and from time to time, we get the dbnetlib error message. This
> error
> message seems to happen when the machine is just idle and is driving me
> nuts.
> The error message doesnt seem to have the issue while the user is actively
> using the application. Could this problem have something to do with
> connection pooling? If anyone has any ideas, it would be much appreciated.
> Thanks in advance!
> Mike Hartman

[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error

We have built an application (VB 6 with a SQL 2000 backend database)
in-house and from time to time, we get the dbnetlib error message. This error
message seems to happen when the machine is just idle and is driving me nuts.
The error message doesnt seem to have the issue while the user is actively
using the application. Could this problem have something to do with
connection pooling? If anyone has any ideas, it would be much appreciated.
Thanks in advance!
Mike Hartman
We have seen this from time-to-time. It seems that the connection "ages out"
after a long period of dormancy. The solution I use is to occasionally poll
the server to make sure it knows that the application is still alive. I
don't think it's a connection pooling issue. It looks like the transport
layer is being closed at the server end (in my case).
USE <initial catalog>
is enough to do the job.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:772A11BE-EF7D-4088-8654-9C29D15F1FCC@.microsoft.com...
> We have built an application (VB 6 with a SQL 2000 backend database)
> in-house and from time to time, we get the dbnetlib error message. This
> error
> message seems to happen when the machine is just idle and is driving me
> nuts.
> The error message doesnt seem to have the issue while the user is actively
> using the application. Could this problem have something to do with
> connection pooling? If anyone has any ideas, it would be much appreciated.
> Thanks in advance!
> Mike Hartman

[DBNETLIB] General Network Error - (I have included the event log dump.)

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.

Thank you for your time, and have a great day.

Cheers,
MarkBasically this means that there is a "connection problem" between the client and server parts of the SQL Server software. The error isn't specific because there are way too many places for these kinds of problems to hide, most of which can't be found by the machine that notices the problem.

If the people are having regular network problems (slowness, problems reaching specific machines in their networks, web browsing issues, etc), then fixing those problems should also fix the SQL problem.

If they aren't having regular network problems, then you have to play a bit of Sherlock Holmes to track down the culprit. If I were in this situation, I'd check:

1. Visit the Windows Update site from each machine using SQL. Be sure to get the latest windows and driver patches.
2. Ping the database server from each machine, investigate any significant differences in ping times.
3. Check the Network Interface Card in each machine (including the server)
4. Check the network hardware (routers, etc)
5. Come back here if that doesn't help.

-PatP

[DBNetLib] ConnectionOpen error

I have a working SQL Server 2000. I use Citrix to run Terminal Server
Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:
"[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
is denied."
As I said , the same App and Same User work fine if I ICA int the box.
THe Only diff is When I RDP into the same box.
An Domain ADMIN will work using both RDP and ICA. Other users will work
in ICA but not RDP.
Anyone have a suggestion where I can look?
jwc
*** Sent via Developersdex http://www.codecomments.com ***
Jim Bob wrote:
> I have a working SQL Server 2000. I use Citrix to run Terminal Server
> Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
> same app and the same user, I get
> an error as follows:
> "[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
> is denied."
> As I said , the same App and Same User work fine if I ICA int the box.
> THe Only diff is When I RDP into the same box.
> An Domain ADMIN will work using both RDP and ICA. Other users will work
> in ICA but not RDP.
> Anyone have a suggestion where I can look?
> jwc
Are you doing remote desktop with rdp or using rdp inside citrix for a
published App? And whats with ica? remote desktop or directly a
published App?
early guess:
Please check the terminal Server / Citrix Server local users. Maybe the
account you are using exists as a local and a domain user and rdp is
using the local account insead of the domain account.
hth
Gregor Stefka
|||I am using a thin client and the RDP protocol (No Citrix).
It seems to be a permission thing possible with DCOM. Are you familiar
with dcomcnfg and How I can use it to grant the proper permissions?
jwc
*** Sent via Developersdex http://www.codecomments.com ***
|||Jim Bob wrote:
> I am using a thin client and the RDP protocol (No Citrix).
> It seems to be a permission thing possible with DCOM. Are you familiar
> with dcomcnfg and How I can use it to grant the proper permissions?
>
Just start dcomcnfg select the component you want to alter the
permissions for. After that you may need to restart the Service/component.
What kind of application you are using? MS Office? individual software?
hth
Stefka
|||It is an internal app that uses a backend SQL Database. The SQL
Database in on another server
jwc
*** Sent via Developersdex http://www.codecomments.com ***
|||OK I have narrowed it down a bit. If I RDP into the Terminal Server
with a Thin Client, I get the error. If I RDP with the same user on the
Terminal Server console and run the App, it works fine.
What is the difference here?
jwc
*** Sent via Developersdex http://www.codecomments.com ***

[DBNetLib] ConnectionOpen error

I have a working SQL Server 2000. I use Citrix to run Terminal Server
Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:
"[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
is denied."
As I said , the same App and Same User work fine if I ICA int the box.
THe Only diff is When I RDP into the same box.
An Domain ADMIN will work using both RDP and ICA. Other users will work
in ICA but not RDP.
Anyone have a suggestion where I can look?
jwc
*** Sent via Developersdex http://www.codecomments.com ***Jim Bob wrote:
> I have a working SQL Server 2000. I use Citrix to run Terminal Server
> Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
> same app and the same user, I get
> an error as follows:
> "[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or acce
ss
> is denied."
> As I said , the same App and Same User work fine if I ICA int the box.
> THe Only diff is When I RDP into the same box.
> An Domain ADMIN will work using both RDP and ICA. Other users will work
> in ICA but not RDP.
> Anyone have a suggestion where I can look?
> jwc
Are you doing remote desktop with rdp or using rdp inside citrix for a
published App? And whats with ica? remote desktop or directly a
published App?
early guess:
Please check the terminal Server / Citrix Server local users. Maybe the
account you are using exists as a local and a domain user and rdp is
using the local account insead of the domain account.
hth
Gregor Stefka|||I am using a thin client and the RDP protocol (No Citrix).
It seems to be a permission thing possible with DCOM. Are you familiar
with dcomcnfg and How I can use it to grant the proper permissions?
jwc
*** Sent via Developersdex http://www.codecomments.com ***|||Jim Bob wrote:
> I am using a thin client and the RDP protocol (No Citrix).
> It seems to be a permission thing possible with DCOM. Are you familiar
> with dcomcnfg and How I can use it to grant the proper permissions?
>
Just start dcomcnfg select the component you want to alter the
permissions for. After that you may need to restart the Service/component.
What kind of application you are using? MS Office? individual software?
hth
Stefka|||It is an internal app that uses a backend SQL Database. The SQL
Database in on another server
jwc
*** Sent via Developersdex http://www.codecomments.com ***|||OK I have narrowed it down a bit. If I RDP into the Terminal Server
with a Thin Client, I get the error. If I RDP with the same user on the
Terminal Server console and run the App, it works fine.
What is the difference here?
jwc
*** Sent via Developersdex http://www.codecomments.com ***

[DBNETLIB] 2147467259(80004005) [Connection Write (Send()),] General Network Error

HI all

I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional.

ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message.

[DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation.

I do so many way to correct this problem but it stuck up overthere.

In vb appendchunk is completed and the error when Updated command starts (update command also going a long way then show the above mentioned error.

Any body have any idea or clue just tel me for experiment. and complete my project.

Once again I request you please help me.

Thanks in advance.

Note : it is working with Access Database very fine I am tested it But in Access not allow me to store me lots of images its only allow 2 GB storage totally in a table.

Error code 0x80004005 is a generic error that indicates something failed. Either the client or server broke the connection.

Two things you should try:

1. Attach SQL Profiler to trace the execution to determine if it is the client or server that is terminating the connection.

2. Check the ERRORLOG if there are any problems with the server.