Claude
I'm betting that you are distributing version 2.1 of the Ms Data Access Components (MDAC_TYP.EXE), when you should be distributing version 2.0 with your application. 2.0 contains the Jet 3.51 driver, while 2.1 contains the Jet 4.0 provider. You want the former, but are probably distributing the latter
download 2.0 SP2 @ http://www.microsoft.com/data
Tom
I am confronted with the following runtime error :
I've developed a VB6 (SP3) project with DataEnvironment and Datareport accessing an Access 97 database.
Since DataEnvironment uses ADO, I set the connection String of the connection's dataEnvironment to : 'Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=\\ondraf\sys\data\dnc\Dox.mdb'
The DataReport uses this connection wich contains a SQL CommandText : 'Select tblSTOCKDNCimp.* from tblSTOCKDNCimp'
The Database is located on our local network.
My Project has the Microsoft ActiveX Data Objects 2.0 Library, MS Data Bindings Collection, MS Data Reports Designer v6.0, MS DataEnvironment Instance 1.0
On My development PC, the application works fine both in the IDE and as the compiled version.
I've made the setup with the Package & Deployment Wizard shipped with VB6, and on some computers on our network, the application report a runtime error when the dataenvironment try to connect to the database.
The error is : "-2147220992", "ADO could not find the specified provider".
On some other PC the applications works fine.
PCs are with Windows 95 R2, Windows 98 First Edition, but the application works on 1 PC 98 and 3 PC 95, and doesn't work on 2 PC 95 and 1 PC 98.
I think there are some missing components in the setup that are already presents on the PCs that work, but I don't know wich one.
The applications also uses DAO 3.51 for displaying records in a grid for the same database, and this feature work fine on all PCs.
Is someone can give little help, it would be welcome.
Thanks
------------------
Claude
That was it.
I reinstall the MDAC_TYP from VB6's CD and it work well.
Thanks a lot.