Morning all,
I have just uploaded a site using classic asp and connecting to a access database as its only a very small site and it was cheap for the client.

Anyway, I'm getting a 500 - Internal Server Error on the page where I'm connecting to the database, and on looking into it on the hosts forums I need to have .net v2, so wondered if anybody could help me change the little amount of code I have so it works on their servers.

The main part of the code is below:

' Get current category
cat = TRIM(Request( "cat" ))
IF cat = "" THEN cat ="Home"
'initialise objects and variables
dim conn, strsql, rsuser, evuser
set conn=server.createobject("ADODB.Connection")
set rsuser=server.createobject("ADODB.Recordset")
strMDBpath = Server.MapPath(".\db_import\EventStyle.mdb")

'direct connection "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & strMDBPath