Keyword
| Meaning
| Values
(bold text denotes the default value)
|
DSN=
| ODBC Data Source Name
| User-supplied name.
|
DBQ=
| TNS Service Name
| User-supplied name.
|
UID=
| User ID or User Name
| User-supplied name.
|
PWD=
| Password
| User-supplied password.
Specify PWD=; for an empty password.
|
DBA=
| Database Attribute
| W=write access.
R=read-only access.
|
APA=
| Applications Attributes
| T=Thread Safety Enabled.
F=Thread Safety Disabled.
|
RST=
| Result Sets
| T=Result Sets Enabled.
F=Result Sets Disabled.
|
QTO=
| Query Timeout Option
| T=Query Timeout Enabled.
F=Query Timeout Disabled.
|
CSR=
| Close Cursor Enabled
| T=Close Cursor Enabled.
F=Close Cursor Disabled.
|
BAM
| Batch Autocommit Mode
| IfAllSuccessful=Comit only if all statements
are successful (old behavior)
UpToFirstFailure=Commit up to first failing
statement (V7 ODBC behavior)
AllSuccessful=Commit all successful
statements (only when connected to an
Oracle8 database; against other databases,
same behavior as V7.)
|
PFC=
| Prefetch Count
| User-supplied numeric value (specify a value of 0 or greater).
The default is 10.
|
FEN=
| Failover Enabled
| T=Failover Enabled.
F=Failover Disabled.
|
FRC=
| Failover Retry Count
| User-supplied numeric value.
The default is 10.
|
FDL=
| Failover Delay
| User-supplied numeric value.
The default is 10.
|
LOB=
| LOB Writes Enabled
| T=LOBs Enabled.
F=LOBs Disabled.
|
FRL=
| Force Retrieval of Oracle Long Column
| T=Forced Long Reads Enabled.
F=Forced Long Reads Disabled.
|
MTS=
| Microsoft Transaction Server Support
| T=Disabled.
F=Enabled.
|
FWC=
| Force SQL_WCHAR Support
| T=Force SQL_WCHAR Enabled.
F=Force SQL_WCHAR Disabled.
|
EXC=
| EXEC Syntax Enabled
| T=EXEC Syntax Enabled
F=EXEC Syntax Disabled
|
XSM=
| Schema Field
| Default=Default
Database=Database Name
Owner=Owner Name
|
TLO=
| Translation Option
| User-supplied numeric value.
The default is 0.
|
TLL=
| Translation Library Name
| User-supplied name.
|
Bookmark
Format of the Connection String (Programming)
