Skip to main content
Indiana Wesleyan University Support Knowledge Base

ODBC Connections


After completing this how-to you will have updated ODBC connections using ODBC Data Sources on the PC, using embedded link in MSQueries and using embedded link in MS Access.

ODBC Data Sources

  1. In the Search box, type ODBC
  2. Click on ODBC Data Sources
  3. Verify that the connections in BOTH User DSN  and System DSN do not say SQL Server for the driver.
    Old Drivers (need to be updated):
    New drivers (set up correctly):
  4. If there is one or more that need to be fixed, here are the steps to re-create it.
    1. Click on the name of the data source ex. beryl.reports
    2. Click Configure...
    3. Screenshot this page - you will need the information later . 
    4. Rename the connection (ex. beryl.reports_old)
    5. Click Finish
    6. Click Add...
    7. Select ODBC Driver 17 for SQL Server (SQL Server Native Client 11.0 will also work if the other one is not available)
    8. Click Finish
    9. Type:
      1. Name: (ex. beryl.reports)
      2. Description: (ex. Warehouse reporting)
      3. Server (ex. warehousedb)
    10. Click Next - nothing needs to be changed on this screen
    11. Click Next - Check the first box - Change the default database to: and type in the database name (ex. reports)
    12. Click Next - nothing needs to be changed on this screen
    13. Click Finish
    14. Click Test Data Source...
    15. You should see this box:
    16. Click OK
    17. Click OK
    18. Verify that you see the new ODBC connection in the list.



These will need to be updated when the ODBC connect from the computer is not used and the connection is embedded into MSQueries.

  1.  Open xlsx file with MSQuery
  2. Click on Data -> Queries & Connections
  3. Click on Connections
  4. Click on Query from beryl and then right click on it -> Click on Properties
  5. Click on Definition -> In Connection string: Replace the words SQL Server with ODBC Driver 17 for SQL Server.  Also make sure if this is for Engagement data, that it looks exactly like this:
  6. Click OK
  7. Save Spreadsheet

MS Access and DSN files

  1. Open the MS Access database file
  2. Right-click on one of the linked tables (ex. dbo_Engagement) -> Linked Table Manager
  3. Click the box and click Edit
  4. In the Connection string: change DRIVER=SQL Server to DRIVER=ODBC Driver 17 for SQL Server
  5. Click Save
  6. Click Relink
  7. Click OK
  8. Click OK
  9. Close Close (it autosaves the connection)


  • Was this article helpful?