Testing the connection
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Service Cloud 7.1
- Documentation
The driver installation includes an ODBC application called example that can be used to connect to a data source and execute SQL. The application is located in the installation_directory/example directory.
To run the program after setting up a data source in the
odbc.ini, enter example and
follow the prompts to enter your data source name, user name, and password. If successful, a
SQL> prompt appears and you can type in SQL statements
such as SELECT * FROM table. If example is unable to connect,
the appropriate error message is returned.