Facility CMIS - How to add a User ODBC Data Source



  • All University machines should now be running a 64-bit version of Windows, therefore the guide will only cover configuration for this architecture.
  • Oracle must be installed from 'UOD Software' prior to following this guide if not already present on your computer.



When opening an MIS file you may sometimes encounter an issue in which the file opens without prompting for login credentials and the connected status within CMIS is listed as 'No'. This means the ODBC Data Source is missing and needs to be added. To do this please follow the steps below;


1.  Navigate to C:\Windows\SysWOW64 and open odbcad32.exe


2.  The ODBC Data Source Administrator dialog box appears.



3.  User DSN should be selected by default so click Add.


4.  Select the 'Oracle in OraClient11g_home1' driver and then click Finish.



5.  Enter the name of the data source (e.g. ) and copy this data into the Description and User ID fields.



If you do not know the TNS Service Name you will need to look this up in the TNSNAMES.ora file located in C:\ORACLE\client\network\admin. Open this file in notepad and search for the name of the server to find the TNS Service Name, before entering this in the Oracle ODBC Driver Configuration dialog box.


In this example we want to connect to the 'testserver' server so we would enter TESTSER1 in the TNS Service Name field.


6.  Click OK to close the Oracle ODBC Driver Configuration dialog box and OK again to close the ODBC Data Source Administrator dialog box.


7.  Verify this by trying to access MIS file again, if you are prompted for credentials and the connection status is listed as 'Connected' this has worked.


Have more questions? Submit a request


Powered by Zendesk