ODBC Connection Problem

ddbruno · #1 (**permalink**) 02-11-05, 08:45

Hello All,

I try not to turn to others for help but I am stumped. When I have an ASP page that trys to connect to an Access database I get an error and the page stops loading, i.e.

Code:

strProvider = "Driver={Microsoft Access Driver (*.mdb)};
   DBQ=somedata.mdb"
set objConn = server.createobject("ADODB.Connection")
'Opens the connection to the data store
objConn.Open strProvider

When the script gets to "objConn.Open strProvider" the page stops loading. This happens on every page and every DB.

I downloaded the latest Jet driver from Microsoft, checked my IIS settings and checked the security/permission settings. No help.

This just started so I am wondering if anyone else has had this problem. I recently installed the .Net beta 2 Framework and was wondering if there was a compatibility issue.

Any help would be great. Thanks, Bruno