都是放在同一个工程里,同一个窗体里面,却出现不同的情况。而且是早上还好好的,下午出现这种情况了,这是什么问题
这条能连上:
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
db.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=weryuk;Data Source=" & "192.168.10.2"
db.Open用下面的却连接不上:
private sub main_load()
Dim IPstr As String, DSstr As String
IPstr = "192.168.10.2"
DSstr = "weryuk"
Dim flag As Boolean
flag = testconn(Trim(IPstr), Trim(DSstr))
If Not flag Then
MsgBox "数据库连接失败!", vbExclamation
Exit Sub
End If
end sub
Public Function testconn(IPstr As String, datastr As String) As Boolean
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=" & datastr & ";Data Source=" & IPstr '全局变量connstr 、conn
Set conn = New ADODB.Connection
On Error GoTo err:
conn.ConnectionTimeout = 1
conn.CommandTimeout = 0
conn.Open connstr
If conn.State = adStateOpen Then
testconn = True
Exit Function
End If
err:
testconn = False
End Function
这条能连上:
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
db.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=weryuk;Data Source=" & "192.168.10.2"
db.Open用下面的却连接不上:
private sub main_load()
Dim IPstr As String, DSstr As String
IPstr = "192.168.10.2"
DSstr = "weryuk"
Dim flag As Boolean
flag = testconn(Trim(IPstr), Trim(DSstr))
If Not flag Then
MsgBox "数据库连接失败!", vbExclamation
Exit Sub
End If
end sub
Public Function testconn(IPstr As String, datastr As String) As Boolean
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=" & datastr & ";Data Source=" & IPstr '全局变量connstr 、conn
Set conn = New ADODB.Connection
On Error GoTo err:
conn.ConnectionTimeout = 1
conn.CommandTimeout = 0
conn.Open connstr
If conn.State = adStateOpen Then
testconn = True
Exit Function
End If
err:
testconn = False
End Function
解决方案 »
- 数据库外键问题
- 如何禁用触发器
- 求助全文索引
- 树型的父子节点的数据表,要实现某一节点下面所有的子节点的sql语句怎么写?
- SQL server7.0连接问题(在线等待,急)
- SQLServer2005安装问题,求解??
- 关于数据的核对问题
- 编辑数据库table间关系有什么用?
- ?十万火急!!!哪位老兄能帮帮我!我在用VB编程时,用鼠标双击MSFlexgrid时,如何定位我双击过的哪一行,哪一格?我已经搞了多少天了,焦头烂额!!!谁能帮我,有100分可以拿!!!我的信箱:[email protected](renzhiguo
- 根據一表中的數據刪除另一個表中的數據
- 关于sqlserver2008列的自动增长
- 深入分析SQL Server 表的主键(下)
LZ下面语句连不上的原因,我猜很可能是在testconn函数中的connstr赋值语句有问题,LZ可以用你上面的connectionstring直接替换测试下就知道了。
你的账号和密码,把你的密码写入到你的连接字符串就可以了