Public conn As New ADODB.Connection ''定义数据连接字符串 Public rs As New ADODB.Recordset ''定义记录集 Dim db As String Private Sub Form_Load() db = "data source=A928;Database=EIMS;server=Localhost;Trusted_Connection=SSPI;" conn.CursorLocation = adUseClient conn.Open db '打开数据库连接 rs.Open "bwcust", conn, adOpenKeyset, adLockPessimistic '打开记录集 rs.Sort = "custid" msgbox rs.RecordCount End Sub
Set g_db = g_ws.OpenDatabase("", False, False, "UID=sa;PWD=myPassword;DATABASE=myServer;DRIVER={SQL SERVER};DSN='';")
Public rs As New ADODB.Recordset ''定义记录集
Dim db As String
Private Sub Form_Load()
db = "data source=A928;Database=EIMS;server=Localhost;Trusted_Connection=SSPI;"
conn.CursorLocation = adUseClient
conn.Open db '打开数据库连接
rs.Open "bwcust", conn, adOpenKeyset, adLockPessimistic '打开记录集
rs.Sort = "custid"
msgbox rs.RecordCount
End Sub