用 ado 动态连接 MDB 时的2种连接字符串的区别?
strMyDb = App.Path & "Data\db.mdb"
ConnectString1 = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & strMyDb & ";PWD=2004" ConnectString2= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & & strAppPath & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=2004"
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open ConnectString1
'cnn.Open ConnectString2
问:
2连接方式有何区别 (ConnectString )
strMyDb = App.Path & "Data\db.mdb"
ConnectString1 = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & strMyDb & ";PWD=2004" ConnectString2= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & & strAppPath & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=2004"
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open ConnectString1
'cnn.Open ConnectString2
问:
2连接方式有何区别 (ConnectString )
ConnectString1 = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & strMyDb & ";PWD=2004"
2、OLE DB方式:
ConnectString2= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & & strAppPath & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=2004"
前种是ODBC连接方式的写法
后者是Microsoft.Jet.OLEDB 连接方式的写法
用那种连接方式,将更好呢?即二者的优劣是什么 ?