Select the Connection Type 'OLEDB Connections' and the Oledb Driver Type of 'Oracle Connection'.
The Data Source is the host name or IP address of the machine running Oracle.
User Id is your username, and Password your password.
Schemas is a comma seperated list of the schemas you would like DataConnect to present in the tile-based drag and drop query editor. You must provide at least one schema name.
Missing Oracle Provider for .NET 4.0
If you attempt to use the Oracle Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.
The message will say:
The Oracle Data Provider for .NET 4.0 cannot be found. Please ensure you have the driver installed and configured correctly.
Contact your system administrator or you can download directly from here:
- For 32 bit Windows http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
- For 64 bit Windows http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
This driver must be installed on the server where the DataConnect Runtime service is installed.
After installing this driver, you may need to reboot the server.