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 http://www.sybase.com/detail?id=1011880.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|