home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
odbcpa22.zip
/
IBOR708.HLP
(
.txt
)
< prev
next >
Wrap
OS/2 Help File
|
1998-04-20
|
4KB
|
73 lines
ΓòÉΓòÉΓòÉ 1. 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.
ΓòÉΓòÉΓòÉ 2. 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.