VB连接sql有密码时连接出错!
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db1
当sql密码为空的时候可以连接到sql
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=123;Initial Catalog=db1
密码为123时sa用户登录失败
当sql密码为空的时候可以连接到sql
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=123;Initial Catalog=db1
密码为123时sa用户登录失败
...全文
请发表友善的回复…
发表回复
--小F-- 2010-06-04
- 打赏
- 举报
VB的 帮顶下
hdh9988 2010-06-04
- 打赏
- 举报
strPubConnect = "Provider=SQLOLEDB.1;Password=12345;Persist Security Info=True;User ID=sa;Initial Catalog=数据库名;Data Source=192.168.1.100"
hdh9988 2010-06-04
- 打赏
- 举报
参考:
strPubConnect = "Provider=SQLOLEDB.1;Password=12345;Persist Security Info=True;User ID=sa;Initial Catalog=guideDB;Data Source=192.168.1.100"
strPubConnect = "Provider=SQLOLEDB.1;Password=12345;Persist Security Info=True;User ID=sa;Initial Catalog=guideDB;Data Source=192.168.1.100"