ASP connect access, delete and change

Environment: IE11, win8.1 x64

Recommended Tutorial: Http://www.w3school.com.cn/asp/index.asp http://www.w3school.com.cn/ado/index.asp

Other, how to turn on iis,access use. It's all about basics or something. Use yourself to search for it.

1. First of all, use script VBScript. Firefox does not support, only use IE.

Check for information such as server errors due to debugging. Need to set the next ie.

"Settings"-"Internet Options"-"advanced"-"suppress the display of friendly HTTP error messages"

This makes it possible to see a server error message. You also need to set up the next server.

2. IIS settings display, error message

Click on the site to find the ASP icon. In the "Compile"-"Debug Properties"-"Send error to Browser" property to "True"

This way the browser will not just display "HTTP 500 server Internal error". Instead, the specific error message is displayed.

3. Error messages

ADODB. Connection error ' 800a0e7a ' was not found for the provider. The program may not be installed correctly. /index.asp, line 4

Find out, is the cause of win7,8 x64.

On the server. "Application Pool"-"Set Application pool default Settings"-"General"-"Enable 32-bit Program" property to "True". You can connect to the Access database normally.

4, asp,access garbled problem solving

http://www.web258.cn/fileshow.asp?id=1176

1. Database Connection Code

<% Set conn = Server.CreateObject ("ADODB. Connection ") Conn. Provider = "Microsoft.Jet.OLEDB.4.0" Conn. Open "D:\data.mdb" database connection can use Direct connect access, for data security, generally use ODBC connection. %>

ASP connect access, delete and change