[轉貼]ODBC或ado connectionstring 設定

[tim]

如果你是用
Microsoft Jet 4.0 Provider Properties
在Extended Properties 的設定如下,可以任何格式


Extended Properties Property Settings
The following table lists the Extended Properties property values to use for the data sources supported by the Jet database engine.

Table 14. Extended Properties property values

Data Source Extended Properties Property value
dBASE dBASE III
dBASE IV
dBASE 5.0
soft Excel Excel 3.0
Excel 4.0
Excel 5.0
Excel 8.0
FoxPro FoxPro tables are accessed by using the Microsoft FoxPro ODBC driver.
Lotus Lotus WK1
Lotus WK3
Lotus WK4
ODBC ODBC
Paradox Paradox 3.x
Paradox 4.x
Paradox 5.x
Paradox 7.x HTML HTML Import
Microsoft Exchange Exchange 4.03
Text Text


1 The Excel 5.0 source database type string is used to specify both Microsoft Excel 5.0 and 7.0 workbooks.

2 The Excel 8.0 source database type string is used to specify both Microsoft Excel 8.0 and 9.0 workbooks.

3 The Exchange 4.0 source database type string is used to specify Microsoft Exchange 4.0, 5.0, and Outlook folders and address books.


微軟官方參考資料:
http://msdn.microsoft.com/library/defau ... topic4.asp

ado connection 參考資料:
http://www.able-consulting.com/ADO_Conn.htm

追加一篇微軟 SQLConfigDataSource

http://msdn.microsoft.com/library/defau ... sdk_59.asp