RE: 32 Bit Application disconnecting from database in the evening

Error message being displayed: "[ODBC SQL Server Driver][Named Pipes]General
network error"
Only happens on windows XP (not sure but may only happen on SP2)

Although giving a code example would be difficult, some background might help

On the launching of our appliction (VC++ MFC App) we create a CDatabase
object that opens a connection to a SQL server database using a DSN. This
connection is kept open for the lifetime of the application. The problem
seems to come that at a random time in the evening (sometime after 6pm) the
software reports the above error when accessing the database. Could this be
that pc's network connection has somehow been disrupted thus invalidating the
connection?

--
Gordon Smith


""Walter Wang [MSFT]"" wrote:

Hi Gordon,

Could you please tell us more about the issue you are having? Such as:

* Any error messages (error dialog, log files, records in event log, etc.)
* What's your system configuration (os version, service pack, database,
driver, etc.)
* Some source code

Thanks.


Regards,
Walter Wang (wawang@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
    ... the database being stopped, or deleted, or something along those lines. ... > System.Data.SqlClient.SqlException: General network error. ... > error today in my production environment, beta environment, ... > app is trying to open a connection using integrated security. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)