Access database connection error, please check the database parameters in the conn.asp file

Today we're going to talk about a real job. To create a Web site using IIS: An Access database connection error, check the resolution of the database parameter settings in the conn.asp file

1, path design error, with Notepad open conn.asp,

If you are an Access database, carefully modify the file name of the following database

db = "Databasepowereasy2006.mdb", the file name of the Access database, use the absolute path relative to the root of the Web site, or modify the file name directly if it is installed in the root directory of the Web site. If it is installed in a directory on a Web site, preceded by this directory, for example, the system is installed in the "http://www.xxx.net/PE2006/" directory (PE2006 is the installation directory), then this should be modified to: db= " Pe2006databasepowereasy2006.mdb "

If the SQL database should be careful to change the SQL2000 authentication mode to Mixed mode

2, database connection address yes.

Open the database with access to discover that the database turned on failed with a wrong type.

Open the database with access and click Tools-Database Utilities-compress and repair databases.

3, database connection address yes.

When you use a batch to clear the system junk file and prompt the database connection error, check the database parameter settings in the Conn.asp file. "It's dead!!!!!

I'll take out the garbage disposal again. Seriously, the first line is: rd/s/q%windir%temp & MD%windir%temp, Halo, delete the windowstemp, and then build a temp. Immediately into Windows, set the security properties of temp, set the users have write permissions, OK, the problem immediately resolved.