My vb application is displaying an error message when it loses sql
connection. My client thinks it has nothing to do with their sql2000
server and tells me they never 'stop and start' sql services. But I
think they do. Is there a way to find out the status of sql connection
from the log? Or are there better ways?

(msxkim@yahoo.com) writes:
> My vb application is displaying an error message when it loses sql
> connection. My client thinks it has nothing to do with their sql2000
> server and tells me they never 'stop and start' sql services. But I
> think they do. Is there a way to find out the status of sql connection
> from the log? Or are there better ways?

So what does your error message say?

You could lose the network connection, if the network is flaky. You could
also loose the connection to SQL server, if there is an execution error
in your SQL Server process, which causes SQL Server to kill that process.
These execution errors (which are usually tokens of bugs in SQL Server)
exhibit themselves as stack dumps in the SQL Server error log.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Once in awhile my vb application display the following message
"Microsoft ODBC SQL server Driver Communication Link" It is very
random. My client tells me there is nothing wrong with their network
because their internet connetion is up and they have been getting all
their mails from exhange server. Is there a way to view sql errorlog
from enterprise manager?

(msxkim@yahoo.com) writes:
> Once in awhile my vb application display the following message
> "Microsoft ODBC SQL server Driver Communication Link"

And that's the complete error message? That does not even look like
an error message to me. But, OK, there is one that continues "...failure",
so I assume that is the one you get.

However, I like reinforce that when we ask you for which error messages
you get, we really want the exact error message, since it may contain
interesting details. And we don't have to guess which error message you
get. (The more we have to guess, the more inaccurate the answer you will
get.)

> It is very random. My client tells me there is nothing wrong with their
> network because their internet connetion is up and they have been
> getting all their mails from exhange server.

A 3-second drop of the connection will not cause any mail queues nor
will it it be noticed by Internet users. But connected services such
as Telnet sessions or SQL Server sessions will be severed.

> Is there a way to view sql errorlog from enterprise manager?

Management->SQL Server logs.

However, it's better if you can get access to the file directly, because
if the log is huge it can take a looooong time to load it into Enterprise
Manager. Also, long lines in the log may be difficult to view in whole
in EM.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp