Accessing MDB with ASP: The specified module could not be found.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Julitta Korol's "Access 2003" book (Wordware). So far it's been
great. However, I'm now trying to go through the Access and Access Server
Pages sections, and am having problems with one of the first exercises.

After copying the files from wordware (and typo checked by me), I have the
following GetCustomer.asp file

<%@ Language=VBScript %>
<HTML>
<HEAD>
<TITLE>Retrieving a Recordset</TITLE>
</HEAD>
<BODY>

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & _
"C:\Learn_ASP\Northwind.mdb"
Set rst = conn.Execute("SELECT CompanyName FROM Customers")
Do While Not rst.EOF
Response.Write rst("CompanyName") & "<BR>"
rst.MoveNext
Loop
%>
</BODY>
</HTML>

When I try to run it in my browser with
http://localhost/GetCustomer

I get an error page:
The specified module could not be found

I have checked that the northwind.mdb is in the correct directory, that the
virtual directory is correctly set (I can see the asp file in the directory
list using http://localhost/

I have tried several different Jet driver / provider instructions to no avail.

I'm running Access 2003 on Windows XP with all the latest updates. Looking
at the source code of the error page doesn't give me any clue as to which
module can't be found.

I don't know if it makes a difference, but I've made sure that ADO and ADOX
are referenced in the northwind.mdb code.

This may be an ASP forum question, but I'm hoping someone here has a clue
about this.

Thanks.
 
I feel stupid for not trying it first, but I don't get the problem with IE,
only with Firefox. Any thoughts as to why and how to fix it?
 
In case I'm not the only idiot - I just discovered that Firefox doesn't
support vbscript. Oops.
 
In case I'm not the only idiot - I just discovered that Firefox
doesn't support vbscript. Oops.
Click to expand...

Nor does any browser except IE, which is why one should never use
VBScript client-side.

But I didn't see any client-side VBScript in your ASP code, so that
really oughtn't be the problem.
 
Back
Top