Creating an ODBC Connection for Chennai Minitab Macros

1. Open Up the Windows Control Panel

  1. Click on "Administrative Tools"
  2. Click on "ODBC Data Source (64-bit)"

2. ODBC Data Source Administrator

A window will come up that will guide you in the set-up of a new ODBC data source for LIMS.

ODBC Data Source Administrator
  1. Click "Add"
  2. Click "SQL Server"
  3. Click "Finish"

3. Microsoft SQL Server DSN Configuration: Part 1

Microsoft SQL Server DSN Configuration: Part 1
  1. Fill out the Name as shows above: "Minitab Chennai"
  2. Fill out the Description as shown above: "Minitab Chennai"
  3. Type in Server name "hkkesr012.as.cksnnet.com"
  4. Click "Next"

4. Microsoft SQL Server DSN Configuration: Part 2 - Authentication

Microsoft SQL Server DSN Configuration: Part 2 - Authentication
  1. Click the second radio button to activate the Login ID and Password box
  2. Enter the login ID as specified below.  The password is "minitab123" without the quotation marks
  3. Click Next to Continue

5. Microsoft SQL Server DSN Configuration: Part 3 - Change the Default Database

  1. Click the check box to activate the drop down box
  2. Click on the drop down to see available DB options
  3. For Chennai you want to select: AChennai
  4. Click Next to proceed

6. Microsoft SQL Server DSN Configuration: Part 4 - Misc Options

Click Finish

Microsoft SQL Server DSN Configuration: Part 4 - Misc Options

7. ODBC Microsoft SQL Server Setup

ODBC Microsoft SQL Server Setup
  1. Click the Test Data Source... button

8. SQL Server ODBC Data Source Test

SQL Server ODBC Data Source Test

If you receive the message shown below, you are finished.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.