ODBC API: SQLConfigDataSource Attribute Names

From: Mark Stasak <mstasak_at_nospam.digital.net>
Date: Sun, 14 Apr 2002 19:24:46 -0400
Message-ID: <ubk3sblspi0a5d@corp.supernews.com>

I had trouble getting SQLConfigDataSource to store attributes into a DSN properly - DSN name, driver name, and description were all that got saved. Google searches found others had the same problem, but no answers. Finally looked at SQORAS32.DLL with a hex editor, and found the internal attribute names needed to create new DSNs:

(Oracle ODBC Driver 8.1.7.0.0)

DSN=dsnname (as expected)
Description=description of DSN (as expected) Server=server name (instead of DBQ=)
User=userid (instead of UID=)
Attributes=W (instead of DBA=)
TrnLib= (instead of TLL=)
TrnOpt=0 (instead of TLO=)
PreFetchCnt=10 (instead of PFC=)
AppAttributes=T (instead of APA=)
Failover=F (instead of FEN=)
FailoverRetryCount=10 (instead of FRC=)
FailoverDelay=10 (instead of FDL=)
Lobs=F (instead of LOB=)
ResultSets=F (instead of RST=)
Longs=F (instead of FRL=)
DisableMTS=F (instead of MTS=)
QueryTimeout=T (instead of QTO=)
CloseCursor=F (instead of CSR=)

Use this with the ODBC help file's connect string reference: 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)
MTS= Microsoft Transaction Server Support (T=Disabled, F=Enabled)
QTO= Query Timeout option (T=Query Timeout Enabled)
CSR= Close Cursor Enabled (T=Close Cursor Enabled, F=(Default) Close Cursor

Disabled)

Hope this helps somebody out! Received on Sun Apr 14 2002 - 18:24:46 CDT