Create Jenzabar ODBC Connection for 32-bit Microsoft Access (Windows 7)

Overview

In order to view Jenzabar-linked data in campus installations of Access using the 32-bit version, you must create a new ODBC connection within the 32-bit ODBC Data Source Administrator. 

IMPORTANT: These are general directions that provide basic instructions for most people. Departments may use different databases and connections 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 a new connection. If you receive any error messages following the directions, please contact the IT Helpdesk for assistance. 

1. Click on the Windows (Start) button and either search or open Computer to browse for the following location and file: C:\Windows\SysWOW64\Odbcad32.exe
2. Double-click on Odbcad32.exe to open.
3. In ODBC Data Source Administrator window, click on the SYSTEM DSN tab.
4. Click Add.
5. Under Create New Data Source, choose SQL Server Native Client 10.0. Click Finish.
6. In the Create a New Data Source to SQL Server window, enter the following:
   • Name: This is the specific name of your ODBC connection. If you are using an Access Database that is already created, you will need to know this name.  EX6: Jenzabar EX is the name commonly used, but your department may use something else. Directions: Manage Linked Tables in Microsoft Access
   • Description: General description, can leave blank or enter Jenzabar EX
   • Server: CCCSQL
7. Click Next.
8. Choose With Integrated Windows authentication.
9. Click Next.
10. 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
11. Click Next.
12. Click Finish.
13. In the new window, click Test Data Source. If all is successful, click OK then close out of all windows.