常见ODBC连接串

SQL SERVER:

 

[ODBC]
DRIVER=SQL Server
UID=user name
DATABASE=database name

APP=Microsoft Data Access Components
SERVER=server name or ip

 

Access:

 

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\Documents and Settings\user\桌面
DBQ=C:\Documents and Settings\user\桌面\db1.mdb


 

 

Excel:

 

[ODBC]
DRIVER=Microsoft Excel Driver (*.xls)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=excel 8.0
DriverId=790
DefaultDir=C:\Documents and Settings\user\桌面
DBQ=C:\Documents and Settings\user\桌面\xx.xls


 

想知道更多的设置，只要在ODBC数据源管理器的“文件DSN”里设置一个，即会保存成文件，打开来看就知道了。