RE: Communications link failure #0
From: John Bell (JohnBell_at_discussions.microsoft.com)
Date: 03/01/05
- Next message: dora: "ASP SQL SERVER CONNECTION"
- Previous message: Ste: "Multiple select in a Store problem"
- In reply to: Scott McDonald: "Communications link failure #0"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 00:27:03 -0800
Hi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:
> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
>
> Any ideas/help would be appreciated.
>
> Thanks!
>
> Scott
>
>
>
- Next message: dora: "ASP SQL SERVER CONNECTION"
- Previous message: Ste: "Multiple select in a Store problem"
- In reply to: Scott McDonald: "Communications link failure #0"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
