Configure Settings via Connection String

  1. Turn on the “Use Connection String” switch and enter the “Connection String” information of the database you want to connect to on the screen that appears.
  2. For Connection String information, enter information in the format “Server= ;Database= ;User Id= ;Password= ;”.
  3. Oracle Server must be open to the internet to provide a connection to an Oracle database you are working on locally.
  4. After entering the information, test whether the Oracle connection is working or not via the “Test” button above. If the Oracle connection is working, create the Datasources connection by clicking the “CREATE” button.

Sample Oracle Data Source

“Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;”

This connection will work smoothly when the user information is entered correctly in the “myServerAddress”, “myDataBase”, “myUsername”, “myPassword” fields.