Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public addFlag As BooleanPublic Function OpenCn() As Boolean
Dim mag As String
On Error GoTo strerrmag
Set conn = New ADODB.Connection
conn.ConnectionTimeout = 25
conn.Provider = "sqloledb"
conn.Properties("data source").Value = "."
conn.Properties("initial catalog").Value = "BookManage"
conn.Properties("integrated security").Value = "SSPI"
conn.Open
OpenCn = True
addFlag = True
Exit Function
strerrmag:
mag = "Data can''t connect"
Call MsgBox(mag, vbOKCancel, "Error:Data connect")
addFlag = False
End
End Function
Public rs As New ADODB.Recordset
Public addFlag As BooleanPublic Function OpenCn() As Boolean
Dim mag As String
On Error GoTo strerrmag
Set conn = New ADODB.Connection
conn.ConnectionTimeout = 25
conn.Provider = "sqloledb"
conn.Properties("data source").Value = "."
conn.Properties("initial catalog").Value = "BookManage"
conn.Properties("integrated security").Value = "SSPI"
conn.Open
OpenCn = True
addFlag = True
Exit Function
strerrmag:
mag = "Data can''t connect"
Call MsgBox(mag, vbOKCancel, "Error:Data connect")
addFlag = False
End
End Function
解决方案 »
- 弹出菜单的问题
- Excel问题,为什么我的EWS1.UsedRange[0].Columns.Count ,EWS1.UsedRange[0].row.Count 都为1
- 请教:我引用里没有Data Access Object选项,怎么定义一个变量为database类型
- 在广州用VB开发的兄弟来这里留个名吧!
- 一个用VB读INI文件的问题,请大侠指教!:)
- 请问如何利用VB抽取PPT文档中的属性啊
- 请问高手,我有个com,怎么把它放在窗体呀,谢了
- 如何判断一个窗体是否是打开的?
- 200分请教EasyMail,详细请看代码
- 请教各位一段代码错误在哪,怎么想也没想明白?
- vb和dbf库之间的问题
- 用户为定义类型错误
难道是这句有问题吗?
把.换成local或服务器名试试
ip地址也可以一般不用这样的方式,而是直接写conn的connectionstring
Dim rs1 As New ADODB.Recordset
db = "Provider=SQLOLEDB.1;Password=abcdef;Persist Security Info=True;User ID=sa;Initial Catalog=test;Data Source=192.168.0.2"
conn.Open dbconn.close
set conn= nonthing