7,763
社区成员
发帖
与我相关
我的任务
分享
Public CONN As ADODB.Connection
Public RS As ADODB.Recordset
Function ConnOpen()
Dim ASTR As String
Set CONN = New ADODB.Connection
ASTR = "f:\Library_Data.MDF"
CONN.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;DataSource=" & ASTR & ";Persist Security Info = False"
CONN.Open
Set RS = New ADODB.Recordset
With Rs Do
ActiveConnection = CONN
CurosorType = adOpenDynamic
LockType = adLockOptimistic
End With
End Function
CONN.ConnectionString = "Provider=MSDASQL.1;Password="admin";Persist Security Info=Ture;DataSource=Library_Data.MDF;Initial Catalog=Library
With RS Do
Public CONN As ADODB.Connection
Public RS As ADODB.Recordset
Function ConnOpen()
Dim ASTR As String
Set CONN = New ADODB.Connection
ASTR = "f:\Library_Data.MDF"
CONN.ConnectionString = "Provider=MSDASQL.1;Password="admin";Persist Security Info=Ture;DataSource=Library_Data.MDF;Initial Catalog=Library"
CONN.Open
Set RS = New ADODB.Recordset
With RS Do
ActiveConnection = CONN
CurosorType = adOpenDynamic
LockType = adLockOptimistic
End With
End Function
Private Sub Form_Load()
Call my.ConnOpen
End Sub
dim conn as new connection
With conn
If .State = adStateOpen Then .Close
.ConnectionString = "driver=SQL Server;server=计算机名或IP地址;uid=SA;pwd=SA的密码;database=数据库名"
.CommandTimeout = 0
.Open
End With