Re: Communications link failure #0

From: Scott McDonald (sdgmcdon_at_yahoo.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 10:49:35 -0800

it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...

"John Bell" <JohnBell@discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@microsoft.com...
> 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
>>
>>
>>

Relevant Pages

  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)
  • Re: Any help here???
    ... > start looking for things that are non standard (like having MDAC installed). ... > Format your drive, do a new/clean install of XP, and go from there. ... >>> data provider is optimized for SQL Server. ... >>> I've never had any SQL Server connectivity problems since I've switch to ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SQL server Login connection failed sqlstate 28000 sql server e
    ... mdac 2.8 - ran the mdac checker and everything is fine ... and reconnect to the sql server using odbc - dsn connection. ... Now when we make mods to the database, reconnect, then we get that error. ... please download Component Checker from the link below to make sure ...
    (microsoft.public.sqlserver.odbc)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: connect to named instances
    ... 'MDAC Utility: Component Checker' ... SQL Server MVP ... >> port number with any MDAC version if it makes you more comfortable. ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
Loading