Intermittent connection loss?

Hi all,
I have a .Net windows application that uses the micrsoft application block
to make calls to the database. I am doing a few thousand records that must
be inserted. I have a problem where on occasion I get an exception that
says "SQL Server does not exist or access denied." This seems to be an
intermittent problem, and profiler has not turned up any info. The server is
running locally, so I don't think it is a network issue.
Anybody have any ideas?
Thanks
J
Are you running the .NET application using TCP/IP or Shared Memory?
Check the sysprocesses table when your application is running & look at the
net_library column to confirm.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Kevin,
I get a timeout period elapsed error when trying to open a connection on a
machine where the server is local. It does not occur when running the same
app on another client on the network. It is a .net application using the
SQLClient. If I turn off shared memory protocol for clients on the server the
error does not occur. Is there an issue with shared memory access and .Net?
"Kevin McDonnell [MSFT]" wrote:

> Are you running the .NET application using TCP/IP or Shared Memory?
> Check the sysprocesses table when your application is running & look at the
> net_library column to confirm.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
|||There may be an issue. I would open a case with a VC engineer in the
Webdata group to investigate.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.