Copyright: , 1995 INTERSOLV


	DataDirect ODBC  Oracle Driver
Logon to Oracle

Oracle ODBC Setup

Copyright


Copyright
Copyright 1995 INTERSOLV Inc. All rights reserved. INTERSOLV is a registered trademark, and DataDirect is a trademark of INTERSOLV, Inc. Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies.


Oracle ODBC Setup
Configuring an Oracle Data Source

Data Source Name:  A string that identifies this Oracle data source configuration in ODBC.INI.  Examples include "Accounting" or "Oracle-Serv1."

Description:  An optional long description of a data source name.  For example, "My Accounting Database" or "Oracle on Server number 1."

Server Name:  The SQL*Net connection string designating the server and database to be accessed.  The information required varies depending on the SQL*Net driver you are using.  The section "Connecting to Oracle Using a Connection String" gives the format of the SQL*Net connection string.

The following values are optional:

Server List:  The list of SQL*Net connection strings that will appear in the logon dialog box.  Separate the strings with commas.  If the SQL*Net connection string contains a comma, enclose it in quotation marks; for example, "Serv,1", "Serv,2", "Serv,3."

Default User Name:  The default user name used to connect to your Oracle database.  A default user name is required only if security is enabled on your database.  Your ODBC application may override this value or you may override this value in the logon dialog box or connection string.

Lock Time Out:  A value that specifies whether Oracle should wait for a lock to be freed before raising an error when processing a Select...For Update Of statement.  Values can be -1 (wait forever) or 0 (don't wait).  The default is -1.

Array Size:  The number of bytes the driver uses for fetching multiple rows.  Values can be 0 to 65536; the default is 60000.  Larger values increase throughput by reducing the number of times the driver fetches data across the network.  Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.

Catalog Comments:  Check this box if you want to retrieve the contents of the COMMENTS column in your Oracle tables.  Doing so may impact the performance of your queries.

Translate: Displays the Select Translator dialog box to allow you to perform a translation of your data from one character set to another. Choose the INTERSOLV OEM ANSI translator to translate your data from the IBM PC character set to the ANSI character set.


Logon to Oracle

Server Name:  Type the SQL*Net connection string of the computer containing the Oracle database tables you wish to access or select the string from the Server Name drop-down list, which displays the names you specified in the Setup dialog box.

User Name:  If required, type your Oracle user name.

Password:  If required, type your Oracle password.