我在ado控件的控件屬性里連接sql server數據是可以連接數據
但在下面寫入代碼就不能連接數據,錯在何處?
Private Sub Form_Load()
Dim strConn As String
Dim strSQL1 As String
Dim conn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Set conn1 = New ADODB.ConnectionstrConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=KHD;Data Source=dfrg"
conn1.Open strConnrs1.CursorLocation = adUseClient strSQL1 = " select * from khb " rs1.Open strSQL1, conn1, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs1
end sub
但在下面寫入代碼就不能連接數據,錯在何處?
Private Sub Form_Load()
Dim strConn As String
Dim strSQL1 As String
Dim conn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Set conn1 = New ADODB.ConnectionstrConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=KHD;Data Source=dfrg"
conn1.Open strConnrs1.CursorLocation = adUseClient strSQL1 = " select * from khb " rs1.Open strSQL1, conn1, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs1
end sub
解决方案 »
- PC和宇电AI706M、702M以及XL-10000称重仪表的串口通信,要求共用一个485总线,出问题了,请教各位!
- 又来劳烦大家了!关于一个时间的问题!!谢谢了!!
- 谁能帮我解释这几句代码(关于WMI的) 谢谢
- vb如何指定mdi子窗体位置
- 用时间控件还是do...doevents...loop?
- 高级问题:我现在需要这么一个功能我该怎么办啊!!!
- 怎样获得Ado中的RecordSet的字段名?
- 在线等,一个打开应用程序的问题
- 如何在 VB 中使用多线程?
- 请高手赐教
- 找不到可安装的ISAM,我已装过了MDAC 2.6和2.7还是不行!!
- 有什么办法知道某个用户正在看图片,并且获得当前打开图片的文件名。
Private Sub Form_Load()
Dim strConn As String
Dim strSQL1 As String
Dim conn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Set conn1 = New ADODB.Connection
'加上Set rs1 = New ADODB.RecordsetstrConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=KHD;Data Source=dfrg"
conn1.Open strConnrs1.CursorLocation = adUseClient strSQL1 = " select * from khb " rs1.Open strSQL1, conn1, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs1
end sub
Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String 'Access 2000的連接
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\North.mdb;Persist Security Info=False"
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerName"
pubConn.Open strConn rsTable.CursorLocation = adUseClient
strSQL = "select * from TableName"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rsTableEnd Sub
還要考慮 tztz520(午夜逛街) ( ) !!!
hdhai9451(※★開拓者...前進☆※) 的不错
你的 strConn 少了 User , pwd !!!!!!!