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

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=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\Inetpub\wwwroot\database\OMHT.mdb;" ' Local
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = 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

Sep 25 '10 #1

Subscribe Post Reply

13111

Nicodemas

164

Expert 100+

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

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

Sep 29 '10 #2

GLSmyth

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

Here is the code I have put together:

Expand|Select|Wrap|Line Numbers

 <% 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

Sep 30 '10 #3

Nicodemas

164

Expert 100+

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.

Sep 30 '10 #4

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

Oct 2 '10 #5

jhardman

3,406

Expert 2GB

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

Oct 4 '10 #6

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

Oct 5 '10 #7

jhardman

3,406

Expert 2GB

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

Jared

Oct 6 '10 #8

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

Oct 6 '10 #9

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

Oct 4 '11 #10

multinett

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

Oct 19 '11 #11

by: sumon | last post by:

Hi, I try to install "pear" on win2k with php 4.3.3 . in Ms/dos when I give C:\>pear list INSTALLED PACKAGES: =================== PACKAGE VERSION STATE Archive_Tar 1.1 stable...

PHP

Debugger is not properly installed

by: N. Okan Guney | last post by:

Hi, When attempting to debug a project on a remote server, I get the error message : "Error while trying to run project: unable to start debugging on the web server. the debugger is not...

.NET Framework

could not perform this operation because the default mail client is not properly installed

by: erikpaulmiller | last post by:

I am trying to open up a blank email message by using the mailto: url. I have noticed that it will work for any value under 2013 characters, but once I have a To: list longer than 2014 chars then I...

Javascript

Provider cannot be found - Using current MDAC and Jet

by: cgraham | last post by:

Hi, I have just upgraded our terminal server to Win 2003 Enterprise Ed on a new Dell server from an older model running Win 2003 Standard Ed. The DB2 client we are using is 7.1, Fixpak 14 and all...

DB2 Database

Visual C# 2K5 Express Edition cannot work properly

by: Zhuyong | last post by:

Hi all I am a newbie from China. I downloaded VCSharp 2005 Expression from MSDN and installed it on my computer.There was no trouble or error during the installation, but after pressing...

.NET Framework

Visual Net cannot found the source code

by: Ivan PequeÃ±o | last post by:

Visual Net cannot found the source code Do you wish to activate the assembler window ? Context Windows Xp-Pro Sp 2 Visual Studio Net 2 Programing Windows.Form Accidentally, I think I have...

.NET Framework

provider cannot be found

by: tshad | last post by:

I am trying to connect to my Sql Server 2000 database from my VS 2003 program and get the "provider cannot be found" when I try to connect to the database. It sees the Server fine but when I tell...

Visual Basic .NET

mod_python not found properly by Apache (win32)

by: bill.simoni | last post by:

I'm unable to get mod_python to work properly on my Windows XP box. Any help would be appreciated. Here is what is installed: Apache 2.2.4 Python 2.5.1 mod_python 3.3.1 for python 2.5 and...

Python

aspx page cannot found

by: Claudia Fong | last post by:

I got this error after creating the virtual directory The page cannot be found The page you are looking for might have been removed, had its name changed, or is temporarily unavailable....

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

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

Similar topics