Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQLConfigDataSource

Re: SQLConfigDataSource

From: DriftWood <drift_wood_at_my-deja.com>
Date: Tue, 19 Dec 2000 21:06:14 GMT
Message-ID: <91oijv$hf2$1@nnrp1.deja.com>

This list is valid for the Oracle 8 driver and can be found in the help file for same. This list may NOT work in 3rd party provided drivers or in the 7.3 versions of the drivers.

Keyword	Meaning
DSN=	ODBC data source name
UID=	User ID or user name
PWD=	Password (specify PWD=; for an empty password)
DBQ=	Service Name
DBA= 	Database attribute (W=write access, R=read-only access)
TLO=	Translation option
TLL=	Translation library name
PFC=	Prefetch count (specify a value zero or greater)
APA=	Applications Attributes (T=Thread Safety Enabled)
FEN=	Failover Enabled (T=Failover Enabled)
FRC=	Failover Retry Count (Number Value)
FDL=	Failover Delay (Number Value)
LOB=	LOBs Writes Enabled (T=LOBs Enabled)
RST=	Results Sets  (T=Result Sets Enabled)
FRL=	Forced Retrieval of Oracle Long Col (T=Forced Long Reads
Enabled)
If the following keyword is specified in the connection string, the Oracle8
ODBC Driver will not read any values defined from the 32-bit Administrator:

DRIVER={Oracle ODBC Driver}

Examples of valid connection strings:

  1. DSN=Personnel;UID=Kotzwinkle;PWD=;
  2. DRIVER={Oracle ODBC Driver};UID=Kotzwinkle;PWD=whatever;DBQ=instl_alias;

DBA=W;
--
-cheers

  DW



"It is a kind of good deed to say well; and yet words are not deeds.   -William Shakespeare"

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 19 2000 - 15:06:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US