这样有错吗？关于连接到sql的

[98060048]

我的server名是ABC
打开连接到sql server的语句是不是这样呀？

......
dim a
set a= Server.CreateObject("ADODB.Connection")
Set oConn = Server.CreateObject("ADODB.Connection")
a.Open "Provider=sqloledb;Data Source=(ABC);Initial Catalog=Pubs;User Id=sa;Password=;"
......

谢谢了

[whose]

Public cn1 As New ADODB.Connection
Public cn2 As New ADODB.Connection
Public rs As New ADODB.Recordset


'建立數據庫連結
If cn1.State = adStateOpen Then cn1.Close
cn1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;Initial Catalog=abc" & _
"Data Source=farwin-main"
cn1.open

[karma]

dim a
set a = Server.CreateObject("ADODB.Connection")
a.Open "Provider=SQLOLEDB;Server=ABC;Database=Pubs;UID=sa;PWD=;"

make sure you can log into your database with UID=sa and empty password