How to create an ODBC Connection

1. Go to Start – Programs – Control Panel – Administrative Tools – ODBC Sources (ODBC).

2. Click on User DSN and Add.

3. Choose SQL Server and hit finish.

4. Type in the Name for this connection, description and the Server Name with instance if there is one. Use format of ServerName\SQLInstance.

5. Choose “With Windows Authentication” which will use the logged in users credentials for the ODBC Connection.

Note: You must have a SQL Login on the Server and be given DB Reader Rights.

6. Check the Box for “Change the default database to:” to point to your database name and hit next.

7. Hit Finish.

8. Select Test Data Source and if it tests out Successful, hit ok until it is closed out.

9. Next go to the program being used to read the ODBC Connection and point the program to this newly created ODBC.