Databases Reference
In-Depth Information
DriverId=790; _
FIL=excel 5.0; _
ImplicitCommitSync=Yes; _
MaxBufferSize=512; _
MaxScanRows=8; _
PageTimeout=5; _
ReadOnly=0; _
SafeTransactions=0; _
Threads=3; _
UID=admin; _
UserCommitSync=Yes;
' Excel DSN connection string
ODBC; _
DSN=ConnectExcel; _
DBQ=D:\BkAccessII\Connect.xls; _
DefaultDir=D:\bkado; _
DriverId=790; _
FIL=excel 5.0; _
MaxBufferSize=512; _
PageTimeout=5; _
UID=admin;
' Text file DSN-less connection string
ODBC; _
DefaultDir=D:\bkado; _
Driver={Microsoft Text Driver (*.txt;*.csv)}; _
DriverId=27; _
Extensions=txt,csv,tab,asc; _
FIL=text; _
ImplicitCommitSync=Yes; _
MaxBufferSize=512; _
MaxScanRows=25; _
PageTimeout=5; _
SafeTransactions=0; _
Threads=3; _
UID=admin; _
UserCommitSync=Yes;
' Text file DSN connection string
ODBC; _
DSN=ConnectText; _
DBQ=D:\bkado; _
DefaultDir=D:\bkado; _
DriverId=27; _
FIL=text; _
MaxBufferSize=512; _
PageTimeout=5; _
UID=admin; _
The main difference between the two types of connection strings is that in a DSN
connection string, the DSN file is referenced so that ODBC can get information from that
file. In a DSN-less string, all required information must be supplied directly. Thus, in
many ways DSN-less connection strings are superior since they do not require an external
DSN file.
