vb连接SQL问题 - VB / 基础类

这样连接数据库是对的
VB code:

Dim conn As New ADODB.Connection
conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=116.28.49.177;USER ID=sa;PASSWORD=123456;DATABASE=data;"





这样就错了，为什么??????????????



VB code:




Dim conn As New ADODB.Connection
dim ip
ip="116.28.49.177"
conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=ip;USER ID=sa;PASSWORD=123456;DATABASE=data;"

---

conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=" & ip & ";USER ID=sa;PASSWORD=123456;DATABASE=data;"

---

回上楼，连不上

弹出错误

“连接的字符串属性无效”

---

conn.Open "Provider=sqloledb;Data Source=116.28.49.177;Initial Catalog=data;User Id=sa;Password=123456;"

---

回上楼，我要改这个
Dim conn As New ADODB.Connection
dim ip
ip="116.28.49.177"
conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=ip;USER ID=sa;PASSWORD=123456;DATABASE=data;" 

---

引用

conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=" & ip & ";USER ID=sa;PASSWORD=123456;DATABASE=data;"

汗,已经回过了,不知lz是否