VB连接远程IP一般的格式是什么?
我看别人是:\\192.168.1.252\test\test.mdb
如果我的IP是123.456.7.890,用户帐户的名称是123,数据库在C:\dd.mdb,
应该怎样写?
我告诉你们!VB连接远程数据库源码:
Public MyConn As String
Public myCnt As ADODB.Connection
Public myRecordset As ADODB.Recordset
Private Sub Command1_Click()
Set Dd1.DataSource = myRecordset.DataSource
DoEvents
End Sub
Private Sub Command2_Click()
On Error Resume Next
myRecordset.AddNew
myRecordset.Fields(0) = "aaa"
myRecordset.Fields(1) = "aaa"
myRecordset.Fields(2) = "aaa"
myRecordset.Update
DoEvents
'myRecordset.Close
End Sub
Private Sub Form_Load()
On Error Resume Next
path2 = Trim(Text1.Text)
Set myCnt = New ADODB.Connection
Set myRecordset = New ADODB.Recordset
myRecordset.CursorLocation = adUseClient
myRecordset.CursorType = adOpenStatic
myRecordset.LockType = adLockBatchOptimistic
fin = " select * from" & Trim(Text2.Text) & " "
MyConn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & path2 & ";"
myCnt.Open MyConn
myRecordset.Open fin, myCnt, adOpenDynamic, adLockPessimistic
DoEvents
End Sub
|
