Setting up the ODBC Data Source Link


In Windows, the ODBC Data Source Administrator is located in the Start menu under the Administrative Tools folder. It is also found under the Control Panel\Administrative Tools.

  1. Open the ODBC Data Source Administrator.
  2. Click on the System DSN tab.
  3. Click Add. You will see a list of available drivers.
  4. Select SQL Server and click Finish. The Create a New Data Source to SQL Server window will open.
  5. Enter the name you want to use to refer to the data source. It may be easiest to use the name ILLiadLink.
  6. Enter a description for the data source.
  7. Select your ILLiad server name to connect to.
  8. Click Next.
  9. Select SQL Server authentication as the method for the SQL server to verify the authenticity of the login ID.
  10. Type in your ILLiadLink login ID and password.
  11. Click Next.
  12. Check the box next to Change the default database to and select ILLData.
  13. Click Next.
  14. Click Finish.
  15. An ODBC Microsoft SQL Server Setup window will appear. This displays the ODBC data source configuration that will be created.
  16. To test the connection, click Test Data Source. It should say Tests Completed Successfully.
  17. Click OK and close the OBCD Application.


If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation: