ODBC Settings For eLab™ and ChartLogic®

Start the ODBC Administrator program.

Under the System DSN tab, find the WINLAB SQL DATA BASE MSSQL7 entry in the list box.

bullet

If the entry is not in the list box, click the Add button.

bullet

If the entry is in the list box, click the Configure button.

In either case, the data entries should be as follows :

bullet

Name : WINLAB SQL DATA BASE MSSQL7

bullet

Description : leave blank or WINLAB SQL DATA BASE MSSQL7

bullet

Server : the name of the server that contains the eLab data base.  This should be the same as the server for ChartLogic.

bullet

The button, "With SQL Server Authentication using a login Id and password entered by the user" should be checked.

bullet

The button "Connection to SQL Server to obtain default settings for the additional configuration options", should be checked.

bullet

Login Id should be "sa" without the quotes.

bullet

Password should be blank.

bullet

The button "Use ANSI Quoted identifiers" should be checked.

bullet

The button "Use ANSI Nulls, paddings and warnings" should be checked.

bullet

The button ""Perform translation for character data" should be checked.

The most common cause of problems is that the Login Id and Password or the Server Name are wrong.