Error reading from Access Database

[Mohammed AM Dwaikat]

Hi Folks

Actually I am new to ASP, I will be thankful so much if anyone could help

I have an Access2000 Database, I have Listing.html that has links to several
ASP Pages, I pass a variable to ASP, And according to variable value I open
the database and get its value

The problem is that sometimes it works fine and sometimes it doesn't

here is the code

<%


DBFilePath= Server.MapPath("pse.mdb")

'the connection string to be passed to the Connection Object

DBConnString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & DBFilePath
& ""

'instanciate a connection oobject

Set connObj = Server.CreateObject("ADODB.Connection")

'Open the connection

connObj.open DBConnString

%>


========== code at the end of asp
</center></div>

<%

'free recordset object memory location and close database connection

RS.Close()

Set RS = Nothing


connObj.close()

set connObj = Nothing

%>

</body>

mostly it gives an error Internal Error, and after several trying I found
the error on this line connObj.open DBConnString, But the page works fine
sometimes and doesn't on another tries

Thank You
Mohammed Dwaikat

[Ray at]

1. Change from that ODBC connection string to an OLEDB connection string.
([url]www.connectionstrings.com[/url])
2. Turn off friendly errors: [url]http://www.aspfaq.com/show.asp?id=2109[/url]

If you still get an error, you'll see what the actual error is then. Post
that here if you can't figure out how to fix it.

Ray at work

"Mohammed AM Dwaikat" <dwaikat@maktoob.com> wrote in message
news:OqOF5j2KEHA.2456@TK2MSFTNGP12.phx.gbl...

>
> The problem is that sometimes it works fine and sometimes it doesn't
>
> here is the code
>
> <%
>
> DBConnString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &

DBFilePath

>
> mostly it gives an error Internal Error

[Mohammed AM Dwaikat]

Highly appreciated for you, It works good, Thanks too much.


Mohammed AM Dwaikat
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:ubw78n6KEHA.3012@tk2msftngp13.phx.gbl...

> 1. Change from that ODBC connection string to an OLEDB connection string.
> ([url]www.connectionstrings.com[/url])
> 2. Turn off friendly errors: [url]http://www.aspfaq.com/show.asp?id=2109[/url]
>
> If you still get an error, you'll see what the actual error is then. Post
> that here if you can't figure out how to fix it.
>
> Ray at work
>
> "Mohammed AM Dwaikat" <dwaikat@maktoob.com> wrote in message
> news:OqOF5j2KEHA.2456@TK2MSFTNGP12.phx.gbl...
>

> >
> > The problem is that sometimes it works fine and sometimes it doesn't
> >
> > here is the code
> >
> > <%
> >
> > DBConnString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &

> DBFilePath

> >
> > mostly it gives an error Internal Error

>
>