This article assumes that you have already launched the Remote Desktop through Azure Virtual Desktop (AVD) and have opened either Microsoft Access or Microsoft Excel. ODBC allows users direct, table-level access to the Banner databases. Please go to Launching Campus Desktop for ODBC Connections (How-to) for more information.
NOTE: If you are a new ODBC user, or if you get an 'Invalid Username/Password' error, you may need to sync your password; please go to https://password.drake.edu/sync/ and log in to sync your password for ODBC use.
See below for information on using the different methods available.
NOTE: Most views used will start with BANINST1, but may start with SATURN or other schemas. If you can't find your needed table/view, please contact ITS.
NOTE: If you wish to access the TEST or TREL Banner databases, select Advanced options, then type either DBQ=TEST or DBQ=TREL in the Connection String field.
NOTE: Most views used will use BANINST1 as the schema, but may start with SATURN or another schema.If you don't know the schema of the table/view you need, try BANINST1. If you need further assistance with this, please contact ITS.
NOTE: If you wish to access the TEST or TREL Banner databases, type either DBQ=TEST or DBQ=TREL in the Connection String field.