How to configure your ODBC drivers

Confirm whether you have [32-bit or 64-bit version of Microsoft office.](https://rollins.teamdynamix.com/TDClient/1835/Portal/KB/ArticleDet?ID=120278)

Open **File Explorer.**

Open the **C: drive.**

Open the **Oracle** folder.

Click on **ODBC Data Sources (xx-bit).** Note: If the bit version does not match the version of Microsoft Office you have installed, contact the Help Desk.

Click on the **System DSN** tab.

Click **Add.**

Search for **Oracle in OraClient 12Home1_32bit** (32 bit version) or **Oracle in OraClient 12Home1** (64 bit version).

Fill out the following information: - Data Source Name: PROD - Description: PROD - TNS Service Name: PROD - Enable Query Timeout: uncheck the box Click **OK**.

Repeat steps 7-9 with PPRD and TEST.

Open the PROD data source that was created and click **Test Connection.**

Log in with your oracle username/password: - If you receive a successful connection pop-up, test your Access query to confirm it is working. - If you receive an incorrect log in message, please [submit a ticket](https://rollins.teamdynamix.com/TDClient/1835/Portal/Requests/TicketRequests/NewForm?ID=5qv9qqLlXpU_&RequestorType=Service).

Close out of the ODBC settings pop-up.