This guide will walk you through installing ODBC drivers and creating a DSN.
***Please be advised, for this to work the DSN needs to be connected to your SIS's database.***
***For Oracle DB's, you will need to install the Oracle Specific driver (11g, 12c etc.) for your DB. It is important to make sure you are downloading the 'Full' version. The light version will not work.
1. Open the Start menu and click Control Panel.
2. Click on System and Security
3. Click on Administrative Tools
NOTE: If you are using a 32-bit Datasource you will need to update the CL-Connect Application Pool settings to allow a connection to be made. You can do so by going to IIS, right clicking on the app pool name, hitting Advanced Settings and changing Enable 32-Bit Applications to True.
4. Right-click your appropriate ODBC DataSources and Run as Adminstrator.
*Note: The 64-bit and 32-bit versions could be named in a confusing manner for Oracle so be cautious at this point.
5. To generate a connection that is available to all users, click the System DSN tab, or if you would like a restricted access DSN you can create a File DSN. Anyone who has access to the file can use a File DSN connection. In either scenario click the appropriate tab and click Add.
6. Choose the driver for the data source and click Finish
7. Add the Name, optionally add a Description, and choose your server.
Note:this is what you will place in the DSN="Name"
8. This is where you would set up the optional UID and PWD, if you would like to skip this merely leave the fields blank and hit Next.
***For the ClientDataBaseConnection Integrated Windows Authentication will not work.***
9. Set up a default database if necessary, then hit Next
10.Click Finish and then test the connection.If the test is successful your DNS is created.
Once the DSN setup is complete, the next step is to create your SIS stored procedure.
Banner Schools, click this link: Banner Stored Procedure
Non-Banner Schools click this link: Non-Banner SIS