How to Establish a Connection to LIMS DB

In order to export data from LIMS DB directly into minitab user must first establish an ODBC connection from their computer.  This has to be done on each computer that wants to utilize minitab macros.  Once a connection is set-up on the computer it is saved and does not need to be done again.

1. Open Minitab

  1. Double click on the minitab icon to open the application
  2. Welcome screen

2. Set-Up DB Connection

  1. Click on "File"
  2. Select "Query Database (ODBC)"

2.1. Set-Up Machine Data Source

  1. Click on tab "Machine Data Source"
  2. Click the "New" button
  3. Click "OK"

2.2. Create New Data Source

  1. Click "Next"
  2. Select "SQL Server"
  3. Click "Next"
  4. Click "Finish"

3. Create a New Data Source to SQL Server

  1. In the "Name" field type: MinitabESGDB
  2. In the "Description" field type: MinitabESGDB
  3. In the "Server" field type: csin0wpdb010.pahprod.pahglobal.net
  4. Press "Next"

3.1. Set-up Authentication

  1. Click the radio button: "With SQL Server authentication using a login ID and password entered by the user"
  2. Type in Login ID: minitab
  3. Type in Password: minitab123
  4. Click "Next"

3.2. Select Database

  1. Checkbox "Change the default database to:"
  2. Click the drop down
  3. Select "enthone" from drop down
  4. Click "Next"
  5. Click "Finish" (nothing should be changed on this window)

3.3. Test Data Source

  1. Click "Test Date Source"
  2. After the testing is completed you should see text "TEST COMPLETED SUCCESSFULLY" Click "OK"
  3. Click "OK"
  4. Click "OK"

3.4. Cancel the Prompt

  1. Click "Cancel"

NOW YOU ARE READY TO USE MINITAB MACROS

0 Comments

Add your comment

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