Testing the connection
- Last Updated: July 15, 2021
- 1 minute read
- DataDirect Connectors
- ODBC
- Apache Spark SQL 8.0
- 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/samples/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.