ASP Database connectity

deepaks85

Hi Friends,

I am very new to ASP and trying to connect a database with Ms-Access with DSN. I have setup the DSN into my hosting account. I don't know how to connect with the database in the ASP. Here is the code I am trying to use:

Expand|Select|Wrap|Line Numbers

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

oConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &

Server.MapPath("") & ";"

oConnection.Close

Set oConnection = Nothing

and I am also getting a Server error which is:

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

Please help me in this.

Thanks

Deepak

jhardman

Quote:

Originally Posted by deepaks85

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

This error is very ambiguous. You need to turn off the "friendly error messages" to find out what the real problem is.

To get the actual error to display, try removing all code (control + x to copy it all to the clipboard for later) write a basic hello world web page and save, hit trefresh to see the hello world, then re-paste your page, save and refresh again. This should show the actual error message.

Jared

Nicodemas

If you already have a DSN setup, you are using the wrong type of connection string. Try the following, substituting your DSN for my sample one.

Expand|Select|Wrap|Line Numbers

 
set conn=Server.CreateObject("ADODB.Connection")

conn.Provider="Microsoft.Jet.OLEDB.4.0"

conn.Open "sample"
 
conn.close

set conn = nothing

ASP Database connectity

re: ASP Database connectity

re: ASP Database connectity

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about