用OLEDB方式,在VB中写代码,参考:Private Sub cmdOK_Click()
On Error GoTo ConnectionError
UserName = txtUserName.Text
UserPass = txtPassword.Text
Dim sConnect As String 'Declare the conection string
sConnect = "Provider=MSDAORA.1;Password=" & UserPass & ";User ID=" & UserName & ";" & _
"Data Source=" & cmbServer & ";Persist Security Info=True" With mADOConnection
.ConnectionString = sConnect
.CommandTimeout = 10 'Stop connection process after 10 sec if fail
.CursorLocation = adUseClient 'Cursor location at client
.Open
End With
On Error GoTo ConnectionError
UserName = txtUserName.Text
UserPass = txtPassword.Text
Dim sConnect As String 'Declare the conection string
sConnect = "Provider=MSDAORA.1;Password=" & UserPass & ";User ID=" & UserName & ";" & _
"Data Source=" & cmbServer & ";Persist Security Info=True" With mADOConnection
.ConnectionString = sConnect
.CommandTimeout = 10 'Stop connection process after 10 sec if fail
.CursorLocation = adUseClient 'Cursor location at client
.Open
End With
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货