ODBCSQL Utility

the Siebel Server installation, there is a utility called odbcsql.exe in the bin folder. It is very useful in troubleshooting connectivity behaviors that stem from the ODBC layer in the installation.

To test the ODBC data source, type the following commands:

Launch the odbcsql utility:

(Microsoft Windows) Navigate to \siebsrvr\BIN and double-click the odbcsql.exe executable.

(UNIX) Make sure you have the Siebel environment variables set appropriately. Navigate to /siebsrvr/bin and type:

./odbcsql

At the ODBC prompt set the SIEBEL_DATASOURCE_NAME to the ODBC data source for which you want to test the connectivity (for example: SiebSrvr_siebel77). On Microsoft Windows, you can navigate to Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) > and click on the System DSN tab to locate the name of the ODBC data source. On UNIX, you can find the Data Source Name in the /siebsrvr/sys/.odbc.ini file.

ODBC> set source

Connect as a user with the appropriate privileges, for example:

login SADMIN/

Execute a SQL statement against any table. For example:

ODBC> SELECT APP_VER, COMMENTS from .S_APP_VER;

This should result in the application version and comments (if any) being displayed and should indicate that the connectivity via the ODBC layer is set up correctly. For example:

ODBC> SELECT APP_VER, COMMENTS from S_APP_VER;
APP_VER COMMENTS
------------------------------ ----------------------------------
V7.7 Database Schema for Siebel 7.7
------------------------------
(query+fetch time: 0.07s, rows fetched: 1, time per row: 0.07s)

Any error messages returned at this point would indicate the following:

There are problems downstream from the ODBC layer to the database or
There are problems in the user and password combination or
There are problems with the SSE_ROLE privileges granted to that user.

You can find additional information in the Siebel Bookshelf version 7.7 > Siebel Installation Guide for (Microsoft Window or UNIX): Servers, Mobile Web Clients, Tools > Installing the Siebel Server: