An error occurs when MSSQL cannot be normally connected in an ASP program:
HTTP/1.1 200 OK Server: Microsoft-IIS/5.1 Date: Sun, 11 Jun 2006 00:59:27 GMT Connection: close Content-Length: 65 Content-Type: text/html Cache-control: private HTTP/1.1 401 error: Access denied. |
Program source file:
<% Dim SqlLocalName, SqlUsername, SqlPassword, SqlDatabaseName, Conn, ConnStr, db, Err_OpenDatabase SqlLocalName = "(local)" 'connection IP Address [local IP Address used outside China] SqlUsername = "sa" 'User Name SqlPassword = "zhengque" 'User Password SqlDatabaseName = "vnut" 'Database Name Set conn = Server. CreateObject ("ADODB. Connection ") Connstr = "Provider = Sqloledb; User ID =" & SqlUsername & "; Password =" & SqlPassword & "; Initial Catalog =" & SqlDatabaseName &"; data Source = "& SqlLocalName &";" Conn. Open connstr Sub CloseConn () On Error Resume Next Conn. close Set Conn = nothing End sub %>
|
The reason is:
Or
Your sa password is incorrect.
Otherwise, your mysql instance is not started.