该怎么写啊 以前从来没做过。帮看看这样写有什么错?
Public con As New ADODB.Connection '定义数据连接字符串
Public rs As New ADODB.Recordset '定义记录集
Public sql As StringPublic Sub openfile()
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
con.ConnectionString = "DRIVER=SQL Server;SERVER=QIANSHUO;APP=Visual Basic;WSID=QIANSHUO;DATABASE=ddy"
' con.ConnectionString = "Driver={SQL Server}; Database=baitai; UID=sa; PWD=sa; Server=192.168.0.110"
con.Open
sql = "select * from baitai"
rs.CursorLocation = adUseClient
' rs.Open sql, con, adOpenKeyset, adLockPessimistic '打开记录集
End Sub
Public con As New ADODB.Connection '定义数据连接字符串
Public rs As New ADODB.Recordset '定义记录集
Public sql As StringPublic Sub openfile()
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
con.ConnectionString = "DRIVER=SQL Server;SERVER=QIANSHUO;APP=Visual Basic;WSID=QIANSHUO;DATABASE=ddy"
' con.ConnectionString = "Driver={SQL Server}; Database=baitai; UID=sa; PWD=sa; Server=192.168.0.110"
con.Open
sql = "select * from baitai"
rs.CursorLocation = adUseClient
' rs.Open sql, con, adOpenKeyset, adLockPessimistic '打开记录集
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货