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ÊÇ·ñ