1. Create the datasource in Admin:
NOTE: Screen shots are from SST (fka DSP) but CranSoft would be the same.
For Oracle:
Horizontal
Vertical - General Tab
NOTE: Enter the Oracle TNSName name in both the Server Address as well as the Database field.
Vertical - Advanced Tab
NOTE: Enter the Connection Timeout and the Command Timeout fields.
For Ole Oracle:
Horizontal
Vertical - General Tab
NOTE:
- Enter database name in the Server Address field, Database field and after the "Data Source=" in the Connection String.
- The Connection string should be as follows:
Provider=ORAOLEDB.Oracle;Data Source=OleOracleDB; User ID=cransoft_admin; Password=w3b4Xing; Fetchsize=10000; - Fetch size is optional but can help performance. The Fetch Size can range from 100 to 10000.
Vertical - Advanced Tab
NOTE: Enter the Connection Timeout and the Command Timeout fields.
2. Test Connection
Click the Test Connection Icon.
If the Test Connection is not successful, please walk through the following guide to validate the set-up of the Oracle Driver: Steps to validate that the Oracle Driver is installed correctly on the web application server for dsp/CranSoft