Public Cn As ADODB.Connection
Set Cn = New ADODB.Connection
Cn.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"User ID=sa;" & _
"Password=;" & _
"Database=DataBaseName;" & _
"Server=YourServerName"
Cn.Open
Set Cn = New ADODB.Connection
Cn.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"User ID=sa;" & _
"Password=;" & _
"Database=DataBaseName;" & _
"Server=YourServerName"
Cn.Open
解决方案 »
- vb如何求,颜色均值
- 如何解决连接SQL数据库超时“死机”的问题?
- 怎样点击datagrid使得图片也跟着发生变化?
- VB如何连接需帐号登录的access97数据库?
- 如何防止我的dbGrid控件的当前编辑的行挪动位置,结果导致错误---"无当前纪录,"--在线
- 题外话:::::::::::::<-------@------------<<<<<<<<<<
- 怎样设计表好?
- 急急急急!怎么样写MSHFlexGrid中行的双击事件?比如双击一行中的数据就显示出一个图片!
- 如何在VB窗口属性0-none时用鼠标可以拖动
- 看来有单独发贴子澄清的必要了
- 如何在StatusBar中添加闪动的Gif图片
- 大虾急救....
用 adodc1:
With adodc1
.connectionstring = cnstr
.username = "sa"
.Password = youpasd
.RecordSource = yousql
.Refresh
End With或者用ADODB:
Dim cnn1 As ADODB.Connection
Dim rst1 As ADODB.Recordset
Set cnn1 = New ADODB.Connection
Call cnn1.Open(cnstr)
Set rst1 = New ADODB.Recordset
rst1.ActiveConnection = cnn1
On Error GoTo errorhandle
Call rst1.Open(yousql, cnn1, adOpenKeyset, adLockReadOnly)
以上这样,不知是否满意?。。
Dim Rs as new adodb.RecordSet
Conn.Open "DSN=test","sa",""Set Rs = Conn.Excute("查询字符串")if Not rs.eof() then