Setting the ODBC Driver Login ID and Specifying Log Files

For UNIX and Windows NT host systems, set a login ID with adequate permissions to enable the workstation BASIS ODBC Driver to communicate with the Data Server, as follows:

  1. In the ODBC Administrator located in the Control Panel of the Windows workstation, select the data source, then click Configure or Setup.

  2. Click Advanced.

  3. Enter the appropriate UNIX login into the Network User ID box. A superuser login should never be specified, as it would be impossible for anyone logged in as superuser to access the Data Server.

  4. To specify a log file to assist in diagnosing ODBC-related problems, do one of the following:

    • To specify a log file for diagnosing data dictionary problems or SQL optimization strategy issues, display the Options dialog and select BASIS ODBC Log File.

    • To specify a log file that monitors all SQL function calls, display the Advanced Options dialog and select SQL Log File.

  5. The BASIS ODBC Driver can now be used from an ODBC-enabled third party application. Refer to the application documentation for specific information concerning connecting to an ODBC or SQL data source.