ASP连接sql server 2000 的代码如何写
我事先是如下写法<% dim mydate
dim cnnb
mydata = "zbroad2009"
cnnStr = "Provider=SQLOLEDB.1; User ID=sa;pwd=111111; Data Source=server02; Initial Catalog=" & mydata
Set cnnb = New ADODB.Connection
cnnb.ConnectionString = cnnStr
cnnb.Open
%>
但是运行错误，请高人指点，该如何写连接的代码，非常感谢
