Provider is not specified?

I recently installed Windows XP Professional 64-bit as I required IIS to test ASP content.

I have a file which works without problem on the hosting server, but when run on my local pc results in an error.

"Provider is not specified and there is no designated default provider"

I'm sure this isn't to do with my DNS less connection, but rather how IIS is setup?

The ASP code is

'Create Database Object.
Dim con
Dim strConn
Dim rs
Dim sqlstmt
'Connect to the database.
set con = Server.CreateObject ("ADODB.Connection")
strConn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/sample.mdb")
con.mode = 3
con.open strConn

Any help or advice is much appreciated.

Cheers

Graham McAllister

Have you checked your pc and made sure that you have the msaccess driver?
If not try using the jet driver like shown below:

Thanks for your help, but yes, I did try using

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("/db/sample.mdb")

and also your code, the result is the same "Provider cannot be found. It may not be properly installed."

I downloaded a file "windowsxp-kb829558-86-enu.exe" from microsoft.com, which I believe is the latest Jet, but
it errors on instal with "This KB829558 is for a different hardware platform."

When I use "Control Panel/Administrative Tools/Data Sources (ODBC)" I have the drivers for Excel, Access and dBase, but I can't
configure them. It errors with "The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could not be found. Please reinstal
the driver."

I'm of the conclusion I either need an updated JET or new drivers to handle 64 bit.

Cheers

Try www.microsoft.com/data to download database drivers.

Thanks Doug but from what I can see from hours scouring the net the news isn't good.

I may be incorrect but the Access drivers are part of msjet40.dll?

According to http://support.microsoft.com the latest version of msjet40.dll is SP8 with
a version number 4.0.8015.0

The version I have that ships with Windows XP 64 bit is 4.00.9025.0, one would reasonably expect
this to be a later version to support 64 bit?

If I try to install SP8 I get the above error "This KB829558 is for a different hardware platform."

I'm no guru, but I'm of the thinking Microsoft have released this version which has a bug, but how
do you contact them for support of their own product without paying $250.00AUD?

If you, or anybody else, can add to this or set me straight I'd appreciate it.

Cheers

I don't know the answer, but MS has been trying to dump Jet for a while now, perhaps it's not available in 64bit windows. I have no experience with 64bit XP myself, sorry.

Much appreciated anyway Doug. Cheers