Home » Objectivity/DB Services

Objectivity/DB SQL++ ODBC Server

This section provides answers to the most commonly asked questions related to Objectivity/DB services.






What is the Objectivity SQL++ ODCB Server?

The Objectivity SQL++ ODCB Server is an executable that accepts the ODBC connection (possibly over a network), parses the SQL statements it receives, and translates these statements into Objectivity/DB operations.


How do I use the SQL++ ODBC server?

To use Objectivity/ODBC, you or your system administrator must perform the following steps:

1. Confirm that the Objectivity/SQL++ ODBC server is properly configured and running. See Objectivity/SQL++ book or the chapter on Objectivity/SQL++ installation in the Installation and Platform Notes for the appropriate platform.

2. Install the Objectivity/SQL++ ODBC Driver on the same host where you plan to use the ODBC-compliant application; see Chapter 2, “Installation on Windows,” and Chapter 3, “Installation on UNIX,” in Objectivity/SQL++ book.

3. Create a data source corresponding to the federated database you need to access; see “Adding Objectivity/DB Data Sources” section in Objectivity/SQL++ book.

4. Use the ODBC-compliant application:
➤ Start the application.
➤ Connect to the data source that you have just configured.
➤ Submit your queries.

Return to top