Provider cannot be found. It may not be properly installed.

[GLSmyth]

I got a new Windows 7 box and am having troubles getting ASP to connect to the database. I have read about this error and it sounds like I need to download and install something but just do not understand what or where. My code is simple:

<% Option Explicit %>
<%
Dim Driver, fso
Driver = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA SOURCE=c:\Inetp ub\wwwroot\data base\OMHT.mdb;" ' Local
Set objCommand = Server.CreateOb ject("ADODB.Com mand")
objCommand.Acti veConnection = Driver
%>

It is the same code I have been using forever so it should work.

If someone can offer me in the simplest terms an explanation as to what I need to install or configure then I would greatly appreciate it.

Cheers -

george

[Nicodemas]

My instincts say it is your MDAC. Try downloading and installing the latest MDAC.

http://www.microsoft.com/downloads/e...displaylang=en

[GLSmyth]

Thanks for the response. I installed it but without any change.

Here is the code I have put together:

<% Option Explicit 
Dim Driver, fso
Dim objCommand
Driver = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\Inetpub\wwwroot\database\OMHT.mdb;" ' Local
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Driver
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head></head>
<body></body>
</html>

The error I am getting is:

ADODB.Command error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/OMHT/test.asp, line 6

Cheers -

george

[Nicodemas]

The Jet drivers were not too many hops from that same link I sent you. Perhaps try downloading those.

If that doesn't work, are you able to use a File DSN? At present you are using DSN-less.

[GLSmyth]

I went to http://www.microsoft.com/downloads/e...&stype=s_basic but the only link that included Jet was for XP. I tried installing it but it would not allow it on my Windows 7 platform.

Cheers -

george

[jhardman]

Yeah, I've been struggling with what db providers are still compatible with windows 7 and Windows server 08. The new ACE OLEDB should have the same functionality - you using Access?

Jared

[GLSmyth]

Yes, I am using a Windows 2000 Access database. I don't want to pay for a whole new package just to be able to continue developing.

Cheers -

george

[jhardman]

Yeah, try Microsoft's ACE OLEDB provider instead of the old Jet OLEDB provider.

Jared

[George L Smyth]

I found the answer. It had to do with an IIS setting that allowed it to work as 32-bit.

Cheers -

george

[Tembss]

Hi George..

Could you be more clear on the answer you discovered. Where on IIS would I find the setting you refer to?

Tembss

[multinett]

you have to active 32-bit application in your application pool!