I've been trying to connect to a simple access database on my IIS server (in house) through ASP but can't connect. I know this is supposed to be the easy part but it's starting to eat away at me. I've tried creating a DSN and now a DSNless connection. I've tried a bunch of different scripts but no luck.
This is the one I'm trying now:

<title>Trial ASP</title>
<body bgcolor="#FFFFFF" text="black">
Dim adoCon
Dim rsNames
Dim strSQL

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("odbc_exmp.mdb")

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

strSQL = "SELECT tblNames.first_name, tblNames.last_name FROM tblNames;"

rsNames.Open strSQL, adoCon

Do While not rsNames.EOF

Response.Write ("<br>")
Response.Write (rsNames("first_name"))
Response.Write ("<br>")
Response.Write (rsNames("last_name"))
Response.Write ("<br>")



Set rsNames = Nothing
Set adoCon = Nothing


I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Can't open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

/DB/names.asp, line 12

Any help? I would appreciate it very much. Thank you.