Recommended: How to design cookies across the domain in Asp Introduction to Cookies First of all, we give a brief introduction to cookies, explaining how to use ASP to maintain cookies. Cookies are small files stored in the client computer, which means that whenever a user visits your site, you can secretly
An error message occurs when the ASP program cannot connect to MSSQL normally.
| The following is the quoted content: 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:
| The following is the quoted content: <% dim SqlLocalName,SqlUsername,SqlPassword,SqlDatabaseName,Conn,ConnStr,db,Err_OpenDatabase SqlLocalName =(local) 'Connect IP [local for local (local) for foreign use IP] SqlUsername =sa 'Username 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 it's
Your sa password is wrong
Or your mysql has not started.
Share: How to use ASP to implement operations on ORACLE database ASP (Active Server Pages) is one of the tools proposed by Microsoft to develop Internet applications. The connection between ASP and databases is generally achieved through ADO (Activex Data Object), just like "Computer World" on March 20, 2000 "Using ASP".