Re: lost connection to sql server`

Well it doesn't seem to be SQL. I had my customer call me the moment they
experienced this again. I checked the sql processes from the server machine
and from there it appeared that the client machine was still connected. But
the client could not connect and had to restart. I also noticed that the
time is random. This can happen in 5 minutes or not at all in over an hour.
It also doesn't seemt to have anything to do with network issues. I've had
it happen on my development machine yesterday. I was away from my computer
for 1/2 hour or so and when I came back and closed the app I'm working on,
it crashed saying that it couldn't connect to the sql server (trying to save
some user settings to one of the tables on close). My development machine is
not connected to any other machines. The sql server and development
environment are all on the same drive. So I'm thinking my app is misbehaving
somehow. Maybe an ADO issue. I don't think a timer to close the connnection
will work because I cannot predict how long this takes to occur. And that
means (unless I'm not understanding that) the user would have to log back in
after I time him out. I'd rather solve the problem than put a bandaid on it
anyway.

Also, I didn't try to ping the server but I did have my customer try to open
a file that resides on the server's HDD from windows explorer from the
workstation. She was able to do that without any trouble so I knwo the
network connection was still fine.

Are there any other tests I can do to see what's going on here? Has nobody
else experienced this sort of thing? I'm a bit lost with this one and have
no idea where to go from here. I have 2 customers using this in beta right
now and expect several others to be using it soon. I need to work this issue
out as soon as poosible. I posted this to the MS SQL Server newsgroup and
haven't heard from anyone at all on this.

TIA,

Keith

"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:45e525a7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
D7 & SQL 2k Peer to peer network with win xp pro machines. The machine the
sql server is on is used as a workstation.

Using TAdoConnection with connection string built in code. All other ado
objects use this connection object.

My app runs fine for hours at a time on all machines. When the user on any
one of the workstations (not the server machine) walks away for 1/2 hour or
so and comes back to use the program (if it's been left running), he gets a
message saying the sql connection has been lost. He has to restart his
entire machine (not just the app) to get things to work again.

This does not happen at all on the server machine. The person running the
app on that machien can leave it running unattended for a couple of hours
and everything is still fine when he comes back.

Any ideas on what's going on here?

Thanks,

Keith




.

Relevant Pages

  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)
  • Re: Timeout problem with SS2K, VS03
    ... I noticed calls in sql profiler: ... This is the server side debug stored procedure. ... a timeout issue that I cannot identify the source of. ... transaction is committed and the connection is closed cleanly and all ...
    (microsoft.public.dotnet.framework.adonet)