Creating ODBC Connections for Jenzabar-linked Access Databases

Step 1:  update your ODBC drivers

  1. Download the msodbcsql.msi file on this page under Files.  (Alternately, you can open File Explorer and browse to \\cccmain\Dept_Data\All Share\ODBC Drivers)
  2. Double-click on the msodbcsql file. Choose Run.
  3. At the Welcome screen, choose Next.
  4. Accept the terms and click Next again.
  5. Drop down the box for ODBC Driver for SQL Server SDK and choose Will be installed on local hard drive.
  6. Click Next and then Install to begin installation. Click Yes to allow installation, then Finish to close window.

Step 2: Add ODBC Connection

  1. In the search bar, search for ODBC Data Source (64-bit)
  2. Click on the System DSN tab, then click Add.
  3. Scroll down the list and choose ODBC Driver 13 for SQL Server, then click Finish. (If you don’t see this, make sure you ran the update in the directions above. You may need to reboot)
  4. For Name, enter the DSN connection name found in your Access database. Most departments use this: EX6: Jenzabar EX
  5. Description can be left blank.
  6. For Server, TYPE JZCCR-SQL1.cedarcrest.local. (using the dropdown takes a long time for windows to search).  Click Next.
  7. Leave "With Integrated Windows authentication" checked, and click Next.
  8. Check the box for Change the default database to:. Using the dropdown, choose your default database name that was listed in your Access database. Leave the rest as is, and click Next.
  9. Leave the defaults as-is, and click Finish.
  10. Click Test Data Source to make sure your information was correct, then click OK on all windows to close.
  11. Re-open your Access database and try to open your linked tables and queries.

 

Print Article