|
|
|
|
|
|
Some MonTel clients cannot connect to the SQL Server or appear to hang on start up
The MonTel client (specifically MonTel32 and Notify32) may appear to hang on start up for a number of different reasons. This topics deals with the issue of failing to get a connection to and SQL database.
Other causes can be related to PABX.INI or DEFAULTS.INI settings. For more information on these and other issues see: What to check if the MonTel client won't start correctly.
The appearance of hanging will depend on various time-out values, see especially LoginTimeout in the [JetODBC] section.
In the end an error message resembling one of the following should appear depending of the type of user:
|
MonTel Administrators |
|
|
Normal users. |
|
The cause could be:
- The MonTel Master Client database has not been rated yet. This should will only happen when MonTel is first installed (that is never for a typical user).
- There is a general or specific network fault, with either the local client or the MSDE or SQL computer (sever).
- The wrong SQL Network library is being used on either the Server (MSDE or SQL) computer, or on the local client. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_client_8uwj.asp for an explanation.
- The number of connections has been exceed on an SQL Server or on a MSDE server where the Named Pipes library has been used. Typically this would occur after about 10 users have successfully logged on, and the Server is running Windows 2000 or XP Professional (and not Server). More information can be obtained from Microsoft http://support.microsoft.com/default.aspx?scid=kb;EN-US;122920. See Occasionally MonTel clients fail to connect to MSDE or SQL Server with Error 71.
For a discussion of the use the SQL Network library in MonTel see: How to select up the correct MS SQL network libraries for MonTel on both the Server and Client.
For a more complete list of MS SQL Server connection issues see the database journal web site at http://www.databasejournal.com/sqletc/article.php/1569851.
On Windows 98 computers you may need to install the Client for Microsoft Networks.
