the following piece of code doesn't seem to work, although it worked fine 

of an other server.



******************

dim dbname, myconnection    

dbname="eerstedb"

    set myconnection=server.CreateObject("ADODB.connection")

    myconnection.Open dbname

******************



I get this error message :



error '800401f9' 

Error in the DLL 



My hosting compagny assures me that they have every necessary components 

installed and that the odbc connection is properly configured...



kind regards,



Bram.(belguim)

Try: "DSN="&dbname

And setup a DSN called 'eerstedb'



-----Original Message-----

From: bram@m... [mailto:bram@m...] 

Sent: Friday, February 22, 2002 7:18 AM

To: Access ASP

Subject: [access_asp] opening odbc connection to acces97 db in asp



the following piece of code doesn't seem to work, although it worked fine 

of an other server.



******************

dim dbname, myconnection    

dbname="eerstedb"

    set myconnection=server.CreateObject("ADODB.connection")

    myconnection.Open dbname

******************



I get this error message :



error '800401f9' 

Error in the DLL 



My hosting compagny assures me that they have every necessary components 

installed and that the odbc connection is properly configured...



kind regards,



Bram.(belguim)

Sorry, but that doesn't seem to do the trick, or otherwise i'm just nor 

adapting my code in the right way (i'm not all that long in to asp)

thanx for the tip though !!



Bram.





> Try: "DSN="&dbname

> And setup a DSN called 'eerstedb'

>