Visual Basic, "Provider cannot be found" runtime error

Martin Underwoo
#1 / 2

"Provider cannot be found" runtime error

I've written a simple database application in VB6. It uses an ADODC control
and a DataGrid control. Having built and installed a package made using
either VB's Package and Deployment Wizard or Installshield, I get a runtime
error when I try to execute the app after (apparently) installing it
successfully:

"Provider cannot be found. It may not be properly installed. Runtime error
91. Object variable or WITH variable not set."

This occurs only on a PC (Win 98 or Win XP) on which VB6 has not been
installed. If I install VB6 and then immediately remove it again, the app
runs OK. This suggests that the app needs a component of VB6 which is
installed and left there even after removal of VB: in other words the list
of DLLs etc that the app requires (and which it gets Package and Deployment
Wizard or Installshield to install) is incomplete.

Has anyone got any suggestions for ways of resolving this problem?

--
"Life is like a sewer: what you get out of it depends on what you put into
it." Tom Lehrer

Remove "NO-SPAM" from email address when replying.

Mon, 08 Aug 2005 23:15:04 GMT

Martin Underwoo
#2 / 2

"Provider cannot be found" runtime error

Quote:

> I've written a simple database application in VB6. It uses an ADODC
control
> and a DataGrid control. Having built and installed a package made using
> either VB's Package and Deployment Wizard or Installshield, I get a
runtime
> error when I try to execute the app after (apparently) installing it
> successfully:

> "Provider cannot be found. It may not be properly installed. Runtime error
> 91. Object variable or WITH variable not set."

I forgot to say that the app is reading an Access database created with
Access 97.

Here's the build report from Installshield, which lists the files that are
bundled into the package:

Build Report

Summary

Number of features:
2

Number of merge modules:
9

Number of dynamic links:
0

Media:
SingleImage

Number of files:
12

Uncompressed files total size:
0.00 MB

Compressed files total size:
0.00 MB

Features

AlwaysInstall

ScannedProject1

Merge Modules

DCOM95

MDAC 2.5 Sp2 (English)

MSDatGrd.OCX

Microsoft ADO Data Control

Microsoft Component Category Manager Library

Microsoft Data Binding Collection Object DLL

Microsoft OLE 2.40 for Windows NT(TM) and Windows 95(TM) Operating
Systems

Microsoft Standard Data Formating Object DLL

Visual Basic Virtual Machine

Dynamic links

Files

File
Destination
Feature
Last Modified
Size (bytes)
Version

db4.mdb
INSTALLDIR
Always Install
02/16/2003 10:10 PM
227328

Entry.exe
INSTALLDIR
Scanned Project1
02/19/2003 10:53 PM
192512
1.0.0.0

comcat.dll
System.3207D1B0_80E5_11D2_B95D_006097C4DE24
Scanned Project1
12/09/1998 12:52 PM
22288
4.71.1460.1

msadodc.ocx
System.7EBEDD1B_AA66_11D2_B980_006097C4DE24
Scanned Project1
05/22/2000 4:58 PM
118976
6.0.88.4

msbind.dll
System.7EBEDD1C_AA66_11D2_B980_006097C4DE24
Scanned Project1
05/11/2000 1:06 PM
77824
6.0.88.62

msdatgrd.ocx
System.7EBEDD20_AA66_11D2_B980_006097C4DE24
Scanned Project1
12/06/2000 1:02 PM
262328
6.0.89.88

msstdfmt.dll
System.7EBEDD3D_AA66_11D2_B980_006097C4DE24
Scanned Project1
04/03/2000 8:05 PM
118784
6.0.88.4

msvbvm60.dll
System.1E64E430_36E0_11D2_A794_0060089A724B
Scanned Project1
11/08/2000 3:02 PM
1388544
6.0.89.64

olepro32.dll
System.8C0C59A0_7DC8_11D2_B95D_006097C4DE24
Scanned Project1
03/08/1999 12:50 PM
164112
5.0.4275.1

stdole2.tlb
System.8C0C59A0_7DC8_11D2_B95D_006097C4DE24
Scanned Project1
03/28/2000 4:58 PM
17920
2.40.4275.1

asycfilt.dll
System.8C0C59A0_7DC8_11D2_B95D_006097C4DE24
Scanned Project1
03/08/1999 12:50 PM
147728
2.40.4275.1

oleaut32.dll
System.8C0C59A0_7DC8_11D2_B95D_006097C4DE24
Scanned Project1
04/12/2000 2:00 PM
598288
2.40.4275.1

Mon, 08 Aug 2005 23:20:18 GMT