ODBC Test Connection

Who is Eligible?

• Anyone with ODBC access and a Windows computer.

Overview

• Testing an ODBC connection is a quick way to verify that your system can successfully communicate with a database using a defined data source. This guide walks you through the steps to locate and test a System DSN on a Windows machine to ensure your configuration is working correctly.

Guide

1. Open ODBC Data Sources (64-bit)
   • Click the Start menu or use the search bar in your Windows taskbar.
   • Type "ODBC" and select ODBC Data Sources (64-bit).
2. Go to the System DSN Tab
   • In the ODBC window, click on the System DSN tab at the top.
3. Select and Configure the ODBC Service
   • Find and select the appropriate Data Source from the list and click it to turn in blue.
   • Click the Configure... button.
4. Test the Connection
   • Click the Test Connection button.​​​​​​​
   • When prompted, log in with your Banner or ODS credentials.

FAQ or Troubleshooting

• Run as Administrator
  • Click the Start menu or use the search bar in your Windows taskbar.
  • Type "ODBC" and right-click the ODBC Data Sources (64-bit) application and select "Run as administrator".
• Check Network Connectivity
  • Make sure your computer is connected to the network or VPN, if required.
• Authentication Errors
  • Make sure you’re entering the correct Banner or ODS username and password.
  • If your credentials were recently changed, try logging in again or restarting your system.
• Verify the oraclient '(M) drive' is mapped and active.

Additional Support

• OU Technology Center
• 44 Oakland Center
• Rochester, MI 48309-4479
• (248) 370-4357
• Office Hours: M-F 8:00am - 5:00pm