如何设置我的SQL server
我用的是win XP系统,在本地安装了sql server 2000(个人版),现在想在本地编辑并调试网页。请问要怎样设置sql server才能使我的网页与服务器连接。请各位老师指教。
<%
On Error Resume Next
Dim ConnStr,Conn
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
DataName = "database1"
DataPass = ""
DataUid = "sa"
DataBaseIO = "."
ConnStr = "Provider = Sqloledb; User ID = " & DataUid & "; Password = " & DataPass & "; Initial Catalog = " & DataName & "; Data Source = " & DataBaseIO & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "连接数据超时,请重新连接!"
Response.End
End If
%>