I found a blame in recent days, that is, when I got the notebook from the development room, my ASP program couldn't connect the SQL Server database. After analysis, it was found that there was no connection to the network. However, because the project I develop is a confidentiality, the computer where the program is located cannot be online, and it is impossible to use SQL Server as a database. After trying to find that the connection address is changed to the computer name!
Put on
<%
Set conn = server.createObject ("adoDb.connection")
DSNTEMP = "driver = {SQL Server}; server = localhost; uid = sa; pwd =; database = manage"
Conn.open DSNTemp
%>
Change to
<%
Set conn = server.createObject ("adoDb.connection")
DSNTEMP = "driver = {SQL Server}; server = your computer name; uid = sa; pwd =; database = manage"
Conn.open DSNTemp
%>
The computer name does not have to say more.
Right click on my computer, the computer name is as shown
