Connection error '800a0e7a' - argh!

[groovygarden]

Hi, I hope someone can help cos this might be the problem that finally sends me mad...

I've created an HTML form which gets a name from the user. This is then passed to an ASP form which is meant to display results from my database where the name field matches the one entered by the user.

However, I get the following error message:

[ADODB.Connection error '800a0e7a' 
ADO could not find the specified provider. 
/test/resultsfp.asp, line 29

The offending Line 29 is:

 myConnection.Open connectString

in context:

dim myConnection
dim rsPuterList
dim connectString
dim sqlString
dim requestType

connectString = "Provider=Microsoft.Jet.OLEDB.4.00;Data Source=trial.mdb;"

Set myConnection = Server.CreateObject("ADODB.Connection")
Set rsPuterList = Server.CreateObject("ADODB.Recordset")

myConnection.Open connectString

Any suggestions would be more than gratefully received! )

Thanks in advance

 

[Geee]

It seems to me that the ASP parser cannot find a driver for the type Microsoft.Jet.OLEDB.4.00. Is this the correct driver for the database. Is this driver installed on the server? We had a similar error when using an Access 2000 database on a server that only had Access 97 drivers installed.

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[link9]

Your connection string seems incomplete, as well.

Here's a link where you can find what it should look like:

http://www.learnasp.com/learn/dbopen.asp

paul

 

[codestorm]

Try something like

connectString = "Driver=Microsoft Access Database (*.mdb);dbq=" & Server.MapPath("trial.mdb&quot

(from memory)

may have to fiddle with it a little bit.

<insert witticism here>
codestorm