I write the following program authors.asp that connect to accsess data base(authors.accdb) and fetch a set of record in the table authors
<%
' create conn as adodb.connection and open it
dim strconn
dim conn
dim rs
strconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\inetpub\wwwroot\Asp_Access_Tp\authors.accdb" & Server.MapPath("C:\inetpub\wwwroot")
set conn = server.createobject("adodb.connection")
conn.open strconn
sql = "select * from Authors"
set rs = conn.execute(sql)
%>
| " & rs("Field1") & " | " & rs("Field2") & " |
when I run this form using internet explorer(version 10.0.92) : http://localhost/Asp_Access_Tp/authors.asp
I have got the following error:
The website cannot display the page
I click on the more info link test I received:
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
any help to solve this problem I appreciate it
thank you
Note : I try to run a test file asp(test.asp) to be sure if the configuration (IIs and Asp)has been well done. http://localhost/Asp_Access_Tp/test.asp
this file is well executed and gave the result "My first ASP script !"
Replies
Know the answer? Post it — somebody with the same question will find it here.