Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » ODBC Configuration window help


Configuration For iAnywhere Driver For Oracle window

This window lets you set configuration information for the ODBC driver for Oracle, which is called iAnywhere Solutions 11 - Oracle.

This tab has the following components:

  • Data source name   Type a name to identify your data source.

  • User ID   Type the default logon ID that the application uses to connect to your Oracle database. A logon ID is required only if security is enabled on your database. If so, contact your system administrator to get your logon ID.

  • Password   Type the password that the application uses to connect to your Oracle database.

  • SID   Type the TNS Service Name. The TNS Service Name is stored in network/admin/tnsnames.ora under your Oracle installation directory.

  • Encrypt password   Select this option if you want the password to be stored in encrypted form in the data source.

  • Procedures Returns Results   Select this option if your procedures can return results. The default is that procedures do not return results (not selected). If your download_cursor or download_delete_cursor scripts are stored procedure invocations, select this option.


    If the Procedure Returns Results option is enabled in your ODBC DSN, the driver caches which procedures require these options. If you change these requirements for a procedure, you must use a new connection.

  • Enable Microsoft distributed transactions   Select option if you want to enlist your transactions in the Microsoft Distributed Transaction Coordinator. When selected, the Oracle ODBC driver requires an Oracle binary file, oramts.dll for Oracle 9i clients or oramts10.dll for Oracle 10g clients.

  • Test Connection   Click to test whether the information provided results in a proper connection. For the test to work, a user ID and password must be specified.

For the latest information about the Oracle driver, see [external link]