Creating an ODBC Connection for West Haven Minitab Macros
1. Open Up the Windows Control Panel
- Click on "Administrative Tools"
- 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.
- Click "Add"
- Click "SQL Server"
- Click "Finish"
3. Microsoft SQL Server DSN Configuration: Part 1
- Fill out the Name as shows above: "ussv074"
- Fill out the Description as shown above: "ussv074"
- Type in Server name "ussv074"
- Click "Next"
4. Microsoft SQL Server DSN Configuration: Part 2 - Authentication
- Click the second radio button to activate the Login ID and Password box
- Enter the login ID as specified below. The password is "minitab123" without the quotation marks
- Click Next to Continue
5. Microsoft SQL Server DSN Configuration: Part 3 - Change the Default Database
- Click the check box to activate the drop down box
- Click on the drop down to see available DB options and select "WinLIMS7"
- Click Next to proceed
6. Microsoft SQL Server DSN Configuration: Part 4 - Misc Options
Click Finish
7. ODBC Microsoft SQL Server Setup
- Click the Test Data Source... button
8. SQL Server ODBC Data Source Test
If you receive the message shown below, you are finished.


0 Comments
Add your comment