DB Library Error SQL Server Connection Timed Out 
Author Message
 DB Library Error SQL Server Connection Timed Out

We have several workstations connecting to a SQL Server via ODBC attached
tables in MS Access 95.

Each workstation was working fine, then one day, they all started crashing.
If a user opens one of the Access databases, Access hangs and they have to
reboot there workstation.  Strangely, this also causes the SQL Server to
fall down.  Every subsequent operation on the SQL Server database, from a
Workstation or the Server causes the above error in the NT Event Log:
    DB Library Error SQL Server Connection Timed Out

You need to look in the Event Log, because nothing else related to the SQL
Server works until the Server is rebooted.

I am not sure at the moment, from which angle to attack this particular
problem.  Is it ODBC, the Network, SQL Server, NT?

The setup is as follows:

Server:
    NT 3.51
    SQL Server 6.0 (named pipes)
    Novell Netware is NOS

Workstation:
    Win95
    MS Access 95
    ODBC 3.0

A few pointers:
    We have had to up the MAX_USER_CONNECTIONS to 128 even though
    there are never more than 5 concurrent users.

    There are hundreds of messages in the Event Log re: Licensing:
        No SQL Server licence exists for ...
        No NT Server licence exists for ...

The really strange thing, is that we have a development replica of this
system which has never had a problem, and another production setup which
also runs fine.

HELP!!!!!!!!!!!!!!

Pat
ATLAS Travel Technologies



Tue, 29 Aug 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Server ODBC connection time-outs?

2. DB-Library SQL server connection timed out

3. SQL Server 6.5 Error: DB-Library Process Dead - Connection Broken

4. SQL Server time outs

5. MS SQL Server 2000 time-outs periodicly over the internet

6. MS SQL Server 2000 time-outs periodicly over the internet

7. SQL DB Library Connection Error

8. Trusted connection to SQL Server 6.5 using DB-Library

9. Mac ODBC 16-bit / DB-Library DBCONNECT / MS SQL Server 7 Connection Problem

10. DB-Library error 10040: DB-Library network communication layer not loaded

11. Continual time-outs (time is not on my side)


 
Powered by phpBB® Forum Software