ADO Connection

When I try to connect I get the following message:

ADODB.Connection error '800a0e7a'

ADO could not find the specified provider.

This is the provider that I am using Provider=MSDASQL.1
I am trying to connect to an Access 97 database.

Does anyone have any clues?:(

You're using the driver for SQL Server. Use the driver for Access.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Databases\test.mdb;

Hi JoshT,
can you tell me what is wrong with this connection string? I still get the same error message..


DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & server.mappath("Program Files\Microsoft Office\Office\Samples\Northwind.mdb")

:)

Your DBQ is wrong.
There are two ways to give the path your database:

1. Using server.mappath
strConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("northwind.mdb")
This give back the right path to your db if it is in that directory where your asp is.

2.You can write the physical phisical path to your db as DBQ
strConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=
c:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"

As far as I know it's worth using the first mode because if the db is a different folder then your web application then it is not sure that you have permission to reach that folder.

Jan

Ps.
Sorry my poor english, but it is after midnight :))
I hope I can help

For Access '97 you should use the Microsoft Jet 3.51 provider.