Public Function openCon(ByVal dbasource As String, dba As String, userid As String, pass As String)
If myCon.State = adStateOpen Then myCon.Close
'myCon.Open "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=aaaa;Data Source=locahost" '正常连接
myCon.Open "Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User ID=userid;Initial Catalog=dba;Data Source=dbasource" '换用了变量后,连接失败
End Function为什么我这里的登陆名、密码、数据库、数据服务换成变量后就连不上去了。有哪些错误啊,
If myCon.State = adStateOpen Then myCon.Close
'myCon.Open "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=aaaa;Data Source=locahost" '正常连接
myCon.Open "Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User ID=userid;Initial Catalog=dba;Data Source=dbasource" '换用了变量后,连接失败
End Function为什么我这里的登陆名、密码、数据库、数据服务换成变量后就连不上去了。有哪些错误啊,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货