本人刚刚学习bv6请问如何实现和数据库的连接,用代码?
谢谢!
谢谢!
解决方案 »
- 有人知道winsock error #10053 “WSAECONNABORTED (10053) Software caused connection abort”? 这种错误原因的引起吗?谢谢
- vb的:"^" 是一个什么操作?
- 如何让Listview中的文字不能编辑
- 谁有成型的ERP,我帮你推广
- 如何编写 update & GROUP BY
- excel问题,100分急问!
- 问一个很菜的问题?
- 关于弹出菜单的问题,请赐教!
- 请问中文字体怎么做的呀?typetrue.
- http://www.dapha.net 计算机图书下载
- 如何用VB代码实现对mssql数据库的备份和恢复?
- 请教高手:用WEBBROWSE或者是IE类对某个服务器操作后,怎么样才能检测服务器返回的是什么信息?比如是404或者是505等等之类的.换句话就是怎
Public Sub DBOpen()
cn.ConnectionTimeout = 25
cn.Provider = "sqloledb"
cn.Properties("Data Source").Value = sServerName
cn.Properties("Initial Catalog").Value = sDatabaseName
cn.Properties("User ID").Value = sUserName
cn.Properties("Password").Value = sPassword
Screen.MousePointer = vbHourglass
cn.Open
Screen.MousePointer = vbDefault
End Sub
分别指定sql服务器名称,数据库名称,用户名称,密码即可
Private Sub Command1_Click()
On Error Resume Next
Dim DBC As New DataBaseConnection
If db.State = 1 Then
db.Close
End If
db.ConnectionString = DBC.SqlConnectString(Text1.Text, Text2.Text, Text3.Text)
rs.CursorType = adOpenDynamic
rs.CursorLocation = adUseClient
rs.LockType = adLockOptimistic
Set cmd.ActiveConnection = db
If Err.Number Then
MsgBox Err.Description, 16 + vbOKOnly, Err.Number
Exit Sub
End If
db.DefaultDatabase = "student1" 'student1换成你要连接的数据库名称
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
If Err.Number Then
MsgBox Err.Description, 16 + vbOKOnly, Err.Number
Exit Sub
End If
Form1.Show
Unload Me
End SubPrivate Sub Command2_Click()
Unload Me
End Sub以上是连接服务器代码Public Function SqlConnectString(ServerName As String, UserName As String, password As String) As String
SqlConnectString = "Provider=SQLOLEDB.1;User ID=" + UserName + ";Pwd=" + password + ";Data Source=" + ServerName
End Function这是类模块DataBaseConnection代码有问题发消息给我!