Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Problems connecting to database useing a DLL in ASP


Message #1 by danielmyburgh@i... on Wed, 20 Sep 2000 12:55:08 +0100
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 !


  Return to Index