Public Function Cnn() As ADODB.Connection '定義函式
Set Cnn = New ADODB.Connection
'回傳一個資料庫連接
Cnn.Open "Driver={SQL Server};Server=(local);Database=db_mainHR;Uid=sa;Pwd="
End Function
Public Function cnStr() As String
cnStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=db_mainHR;Data Source=計算機名"
End Function
uj5u.com熱心網友回復：
conn.ConnectionString = "driver=SQL Server;server=計算機名或IP地址;uid=SA;pwd=SA的密碼;database=資料庫名"conn.open
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/125057.html
上一篇：請教各位大神，小妹看不懂這兩兩個函式干什么用的，具體怎么呼叫？
下一篇：客戶端無法建立連接