This is a discussion on SQL Disconnects Intermittenly During Day within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have two users who are being disconnected from the server intermitently during the day. We're running Access 2000 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have two users who are being disconnected from the server intermitently during the day. We're running Access 2000 and Great Plains. It appears that the odbc connections are stepping on each other somehow. The error message is Connection Failed: Sqlstate 01000. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()) Connection Failed. SQL State 08001 Server Not Found. This has only started to happen after we upgraded to GP 8, Sql Server 2000 and Windows Server 2003. Can anyone help? |