This guide will walk you through installing ODBC drivers and creating a DSN.
***Please advise, for this to work the DSN needs to be connected to your SIS database.***
For Oracle databases, 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 search for/open Control Panel.
2. Click on System and Security.
3. Click on Administrative Tools.
NOTE: If you are using a 32-bit Data Source you will need to update the CL-Connect Application Pool Settings to allow a connection to be made. You can do so by going into IIS, right-click on the app pool name, select Advanced Settings and toggle Enable 32-Bit version to True.
4. Right-click your appropriate ODBC Data Sources and Run as Administrator.
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, choose your server, and click Next.
NOTE: This is what you will place in the DSN="Name"
8. This is where you would set up the optional Login ID and Password, if you would like to skip this merely leave the fields blank and hit Next.
NOTE: 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. See next steps below.
Troubleshooting: ODBC and Stored Procedure Common Issues
Next Steps: Event Notifications - Stored Procedure