running DataReport shows 'Invalid data source'

[WBH1138]

Hi

I have written a DataReport in VB6 that I am now running from another PC.

I get the message "Invalid data source" - there is no RTE or any other information.

I am using a DataEnvironment, etc, at design time to link to a local database to give me the fields to design the report, but then overwriting the relevant information in VB code at runtime i.e.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gsDatabaselocation$ & "\Televet.mdb" & ";User Id=admin;Password=;"

I've tested it locally against databases in a different location to the design time location.

The databases to be used are Access 97 and 2K. The failing PC is running Vista, but I haven't had chance to test on an independant XP machine yet.

Thanks in advance

 

[WBH1138]

Ah-hah!

It seems I've sorted it myself.

I had already made sure the following files were installed and registered;

C:\Windows\System32\msdrptr.dll
C:\Program Files\Common Files\Designer\msderun.dll
C:\Windows\System32\msstdfmt.dll

But was waiting to get access to this PC to check;
C:\Windows\System32\msdatrep.ocx
C:\Windows\System32\msbind.dll

With those installed and registered, report ran OK

BTW we don't use the Package and Deployment Wizard.

Hope someone else finds this useful!

 

[genomon]

We install MDAC on all the target machines just in case.

"Teamwork means never having to take all the blame yourself."

 

[WBH1138]

Thanks for that. I have seen that MDAC may be required.

I'm not keen on just banging .dlls etc on machines for the sake of it though.

Are there any issues of putting MDAC on a users machine?

 

[genomon]

The only issue I know of is that the install package can be way smaller since you don't need to include all the ADOX stuff.

"Teamwork means never having to take all the blame yourself."