set cn=new adocb.connect cn.open "Provider=Microsoft.Jet.OLEDB.3.5;Data Source=www.52stuy.com/aaa.mdb ;Persist Security Info=False" cn.excute "insert into aaa (fff) values (1)" cn.close set cn=nothing
dim cn as adodb.Connection dim rs as adodb.recordsetset cn=new adodb.connection cn.cope "rovider=Microsoft.Jet.OLEDB.3.5;Data Source=www.52stuy.com/aaa.mdb ;Persist Security Info=False"Set rs=new adodb.recordsetrs.open "select * from aaa",cn, adOpenKeyset,adLockOptimistic rs.addnew rs!fields("fff")=1 '如果字段类型是字符则用 'rs!fields(fff")="1" rs.updaters.close cn.closeset rs=nothing set cn=nothing
可以直接弹出DataLink属性框,你可以选择Provider和数据源位置 <<<<<<<<<<<<<<<<Code>>>>>>>>>>>>>>> Public Function GetConnectDSN(ByVal DSN As String) As String Dim c As DataLinks Dim d As ADODB.Connection Set c = New DataLinks Set d = New ADODB.Connection d.ConnectionString = DSN If c.PromptEdit(d) = True Then GetConnectDSN = d.ConnectionString mvarLastDSN = d.ConnectionString mvarConnectResult = True Else mvarConnectResult = False GetConnectDSN = "" End If Set d = Nothing End Function Public Function ConnectDB(ByVal DSN As String) As String If DSN <> "" Then ConnectDB = GetConnectDSN(DSN) Else
ConnectDB = GetConnectDSN("") Dim i As Integer End If End FunctionPublic Property Get ConnectResult() As Boolean ConnectResult = mvarConnectResult End PropertyPublic Function OpenConnection(DSN As String) As String Set CONN = New ADODB.Connection CONN.ConnectionString = DSN CONN.CursorLocation = adUseClient On Error GoTo ErrHandle CONN.Open OpenConnection = DSN Exit Function ErrHandle: DSN = "" DSN = ConnectDB(DSN) CONN.ConnectionString = DSN CONN.CursorLocation = adUseClient CONN.Open OpenConnection = DSN End Function
www.xxxx.com/xxxx.mdb
怎么用ado打开这个数据库?
cn.open "Provider=Microsoft.Jet.OLEDB.3.5;Data Source=www.52stuy.com/aaa.mdb ;Persist Security Info=False"
cn.excute "insert into aaa (fff) values (1)"
cn.close
set cn=nothing
dim rs as adodb.recordsetset cn=new adodb.connection
cn.cope "rovider=Microsoft.Jet.OLEDB.3.5;Data Source=www.52stuy.com/aaa.mdb ;Persist Security Info=False"Set rs=new adodb.recordsetrs.open "select * from aaa",cn, adOpenKeyset,adLockOptimistic rs.addnew
rs!fields("fff")=1
'如果字段类型是字符则用
'rs!fields(fff")="1"
rs.updaters.close
cn.closeset rs=nothing
set cn=nothing
<<<<<<<<<<<<<<<<Code>>>>>>>>>>>>>>>
Public Function GetConnectDSN(ByVal DSN As String) As String
Dim c As DataLinks
Dim d As ADODB.Connection
Set c = New DataLinks
Set d = New ADODB.Connection
d.ConnectionString = DSN
If c.PromptEdit(d) = True Then
GetConnectDSN = d.ConnectionString
mvarLastDSN = d.ConnectionString
mvarConnectResult = True
Else
mvarConnectResult = False
GetConnectDSN = ""
End If
Set d = Nothing
End Function
Public Function ConnectDB(ByVal DSN As String) As String
If DSN <> "" Then
ConnectDB = GetConnectDSN(DSN)
Else
ConnectDB = GetConnectDSN("")
Dim i As Integer
End If
End FunctionPublic Property Get ConnectResult() As Boolean
ConnectResult = mvarConnectResult
End PropertyPublic Function OpenConnection(DSN As String) As String
Set CONN = New ADODB.Connection
CONN.ConnectionString = DSN
CONN.CursorLocation = adUseClient
On Error GoTo ErrHandle
CONN.Open
OpenConnection = DSN
Exit Function
ErrHandle:
DSN = ""
DSN = ConnectDB(DSN)
CONN.ConnectionString = DSN
CONN.CursorLocation = adUseClient
CONN.Open
OpenConnection = DSN
End Function
之类的错误!没有一个能运行的。
cn.cope "rovider=Microsoft.Jet.OLEDB.3.5;Data Source=www.52stuy.com/aaa.mdb ;Persist Security
比如这句!.cope干脆就说不支持这个方法。
改成.open就说没有指定数据库驱动程序。