Querying the Sample Data Source
- Last Updated: April 5, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
You can now use the Interactive SQL for ODBC tool to execute queries against the Default data source. The Interactive SQL for ODBC can be used to execute ad-hoc queries. Refer to the OpenAccess SDK Administrator’s Guide.
The following sample session for Windows that assumes a User DSN mydsn was created in Connecting to the Sample Data Source for the Default server data source.
-
Start Interactive SQL (ODBC) by double-clicking its icon from the DataDirect OpenAccess SDK/Client for ODBC program group.
-
From the Interactive SQL prompt, type:
CONNECT pooh*bear@mydsn
-
From the Interactive SQL prompt, enter in a SQL query. For example, type:
SELECT * FROM emp;
-
From the Interactive SQL prompt, type:
EXIT