How to resolve ADODB.Command (0x800A0E7A) error

[jmartmem]

I have this very confounding connections problem that I hope someone can help me with.

I've created an ASP page (pic.asp). On this page I used the Record Insertion Form Wizard to insert a Data Object on this page, which contains a number of controls in an Access 2007 database table.

Once created, I filled in sample data in a few text fields and tested whether or not I could insert a record, but I keep getting a 'This page cannot be displayed' error in my browser (IE7.0) as follows:

Error Type:
ADODB.Command (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/ez/pic.asp, line 31

Line 31 in my code reads:

MM_editCmd.ActiveConnection = MM_EZTrackingTool_STRING

I've tested the connection string to my database and it works fine, but I continuously get this error whenever I create a recordset.

I've just started using ASP via Dreamweaver. Any suggestions would be greatly appreciated.

[jeffstl]

I have this very confounding connections problem that I hope someone can help me with.

I've created an ASP page (pic.asp). On this page I used the Record Insertion Form Wizard to insert a Data Object on this page, which contains a number of controls in an Access 2007 database table.

Once created, I filled in sample data in a few text fields and tested whether or not I could insert a record, but I keep getting a 'This page cannot be displayed' error in my browser (IE7.0) as follows:

Error Type:
ADODB.Command (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/ez/pic.asp, line 31

Line 31 in my code reads:

MM_editCmd.ActiveConnection = MM_EZTrackingTool_STRING

I've tested the connection string to my database and it works fine, but I continuously get this error whenever I create a recordset.

I've just started using ASP via Dreamweaver. Any suggestions would be greatly appreciated.

What provider do you have set to reference on your database connection?

Below is code I would use to connect to an Access database on a classic asp application on an IIS server.

The provider is the MS jet engine 4.0.

DBName = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & default_DB_Path & ";"
Set default_DB_conn = Server.CreateObject("ADODB.Connection")
default_DB_conn.Open DBName
 
 

[jmartmem]

That did the trick. I corrected my connection and everything worked fine. Thanks!