Added: July/05/2005 at 5:11am | IP Logged

I am doing an access database connectivity with asp. I have included the adovbs.inc in my asp code. and i have written codes by which i can retrieve the records from the table. But when i click on the submit button(which is there in another asp file) it gives me page cannot be displayed error. But when i remove this code and put a simple response.write,it works. Pls help me to solve this problem asap.Hope u got the scenario. This is the code::

<!-- #include file="adovbs.inc" -->

<%

Dim Conn
dim rsResults1
Dim SQLstr

Set conn = server.createobject("ADODB.Connection")

Conn.open "Library"

Set rsResults1=Server.CreateObject("ADODB.Recordset")

SQLstr="Select count(*) as mcount from user where user_name='" & Trim(request.Form("txt_name")) &"'"

rsResults1=conn.execute(SQLstr)

Added: July/06/2005 at 10:09pm | IP Logged

are you not seeing the real error perhaps ?

http://www.powerasp.com/content/hintstips/common_sense.asp

Added: May/27/2006 at 9:25am | IP Logged

first you have oppened the connection to the databse in a wrong way. it should look like this

Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("webissuelogboek.mdb")

after doing that follow the pictures below to show the reall error and tell you at which line the error is accuring

to show the reall error follow the steps in the picture

and when u press OK

refresh the page, and whenever there is an error it will display the real error with the line where the error had accured

Hope this helps

Tell what happens with u

Best Regards