Fixing ODBC Connection to EX6: Jenzabar EX failed error in Access

Overview

When Cedar Crest originally moved to Jenzabar's Cloud Services, our campus was running the 32-bit version of Microsoft Office (including Access).  Since these configurations carry over from one computer to another, you may find that your new (64-bit) computer has issues running Microsoft Access databases previously created in 32-bit Access and accessing Jenzabar.  When you attempt to do so, you get this error: ODBC--connection to 'EX6: Jenzabar EX' failed (or similar).

To fix this error, you must delete the 32-bit ODBC connection, and create a new 64-bit ODBC connection.

IMPORTANT: These are general directions that provide basic instructions for most people. Departments may use different databases and connection names, so please check with your department or contact Information Technology if you have any questions. 

Directions

NOTE: You must be logged in with Administrative rights in order to create or modify ODBC connections. If you receive any error messages following these directions, please contact the IT Helpdesk for assistance. 

1. Click on the Windows (Start) button and either search for, or find the ODBC Data Sources (32-bit) and open the program.
   
   
    
2. Next, click on System DSN.
3. Then click on the entry labeled EX6: Jenzabar EX (or the name of the connection you need to remove) and click Remove.
4. Now, close the ODBC Data Sources (32-bit), and repeat the steps to find and open ODBC Data Sources (64-bit).
5. Next, click on System DSN​​​​​​​.
6. Click Add.
7. Under Create New Data Source, choose ODBC Driver 13 for SQL Server and click Finish.
8. You will be shown a new window that says Create New Data Source.  Enter the following:
   • Name: EX: Jenzabar EX (or the appropriate name of your connection. Note, this is important - your Access database will not work if the name is not correct).
     Description: General description, can leave blank or enter Jenzabar EX
   • Server: CCCSQL
9. Click Next.
10. Choose With Integrated Windows authentication.
11. Click Next.
12. If you do not need to change the default database from tmseprd, leave all defaults and click Next. Otherwise, click Change the default database to box and select the correct table. If you are not sure of the table name you need for a current Access Database, directions can be found here: Directions: Manage Linked Tables in Microsoft Access
13. Click Next.
14. Click Finish.
15. In the new window, click Test Data Source. If all is successful, click OK then close out of all windows.