Establishing a Connection
To connect to Oracle, you'll first need to update your PATH variable and ensure it contains a folder location that includes the native dlls. The native dlls can be found in the lib folder inside the installation directory of the provider. Once you've done this, set the following to connect:
- Port: The port used to connect to the server hosting the Oracle database.
- User: The user Id provided for authentication with the Oracle database.
- Password: The password provided for authentication with the Oracle database.
- Service Name: The service name of the Oracle database.