ADO 8007007f error

[arlequin]

Hello, there:

I've a simple ASP (not .NET) script which tries to open a connection to an Access database. Quite simple...

Running on Windows XP's IIS.
I get the 8007007f error on line 5, which follows:

<%
    Dim BD
    dbPath = &quot;C:\Inetpub\SAG\javier\inmobiliaria.mdb&quot;
    Set BD = Server.CreateObject(&quot;ADODB.Connection&quot;)
    BD.Open &quot;PROVIDER=Microsoft.Jet.OLEDB.4.0;&quot; + &quot;DATA SOURCE&quot; & dbPath
%>

I've downloaded & installed the las MDAC version from MS website, but I can't get through.....
Does anyone have had this error?

IE dump follows:

Error type:
Server Object, ASP 0177 (0x8007007F)
8007007f
/javier/index.asp, line 5


N.B.: Server and browser are in Spanish version, I've translated the error to English....


Thanks in advance,

Arlequín
arlequin_AT_internet_DOT_com_DOT_uy

 

[YNOTU]

http://aspfaq.com/show.asp?id=2134

also, try this arlequin:



<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<%

'-------------------------- DIM ALL VARIABLES
Dim rsEmployees, mySQL, connEmployees

'-------------------------- Create Connection
Set connEmployees = Server.CreateObject(&quot;ADODB.Connection&quot

'-------------------------- Set/Point Connection
connEmployees.open &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:\Inetpub\

http://wwwroot\folder\DATABASE.mdb&quot;

'-------------------------- Create the Recordset
Set rsEmployees = Server.CreateObject(&quot;ADODB.Recordset&quot

'-------------------------- Create the SQL Statement that pulls from the DataBase
mySQL=&quot;Select * from tblEmployee&quot;
rsEmployees.open mySQL, connEmployees
%>