加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MsSql教程 > 正文

connect local sqlserver

发布时间:2020-12-12 15:48:45 所属栏目:MsSql教程 来源:网络整理
导读:1)setup 2) connect will be ok conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=jevons;PWD=jevons;DATABASE=master" ? but if the data source are not (local) connection will be failed,I don’t know why. ? 'ok conn.open "PROVIDER=SQLOLEDB;
1)setup










2)

connect will be ok

conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=jevons;PWD=jevons;DATABASE=master"

?

but if the data source are not (local) connection will be failed,I don’t know why.

?

'ok conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=jevons;PWD=jevons;DATABASE=master"

?

'failed conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=WWW-01785772227;UID=jevons;PWD=jevons;DATABASE=master"

'failed conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=jevons;PWD=jevons;DATABASE=master"

?

'failed conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=(localhost);UID=jevons;PWD=jevons;DATABASE=master"

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读