473,320 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Connection Log

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?

Jul 23 '05 #1
3 6728
(ms****@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
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?

Jul 23 '05 #3
(ms****@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: G-Fit | last post by:
Hello group, I have several servers hosting SQL databases. On each of them, I have several databases. All those databases have the same structure (even those on different servers), only the data...
11
by: pradeep_TP | last post by:
Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...
35
by: Eric Sabine | last post by:
In my Finally block, I was using cn.close (where cn is an ADO.NET connection object, SQLConnection to be exact) and then I came across the following in some microsoft code. If Not cn Is Nothing...
3
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...
35
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
20
by: fniles | last post by:
I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...
3
by: fniles | last post by:
In the Windows application (using VB.NET 2005) I use connection pooling like the following: In the main form load I open a connection using a connection string that I stored in a global variable...
6
Cintury
by: Cintury | last post by:
Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...
0
by: Robert Avery | last post by:
In VBA/VB6, I had a class (incomplete sample below) that watched and displayed for the user all connection events, so that I could easily see what SQL was taking a long time, and when it freezes, I...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.