ODBC Connections

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.

MSQueries

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 Serve with ODBC Driver 17 for SQL Server
   
6. Click OK
7. Save Spreadsheet