Hi
I?ve got a ASP application that connects to an Access database and
displays three fields from the Employee table. This works fine and I now
want to do the same by using a DLL for the database connection and
Recordset retrieval.
I?m using the same code in the DLL to connect to the server plus I?ve
tested the component in normal form based VB Application where it works
fine. When I use it in the ASP page though I get an Error.
Here is the ASP code.
<%
Option Explicit
Dim MyObject
Set MyObject = Server.CreateObject(SampleServer.Employee)
Response.write MyObject.EmpInfo
%>
The problem is not with the connecting to DLL object because if I create a
DLL that returns a String without any Database connections/retrievals
then it works fine. So It seems like everything points to the Database
connection inside the DLL but I?ve got no idea what the problem can be.
Here is the Error message from the ASP page.
Microsoft OLE DB Provider for ODBC Drivers error 8004005[Microsoft][ODBC
Access 97 ODBC driver Driver] General error Unable to open registry key
?DriverId?
Well I hope this is not as clear as mud !
And thanks for the help
Daniel
Ps. Boy do I hate being a newbie !