DataReport : Error 429

[cbsm]

I am using VB6 - with an Access database.
I've created a few reports (with dataenvironment) - they are all working fine ... on my machine.
I used the Visual studio deployment too and installed the programm on someone else's PC.
Everything works fine but the reports.
The error 429 ActivX can't create object error occurs and the report does not open.
I checked and the dll : Msdrptr.dll seems to be registered on this machine (I found it afew times doing a search in regedit).
There is one thing I need to add. Access is not installed on the user's machine.
But I have no problem querying the database in the application. I believe this could be the problem, but have no way to check.

Any suggestion is welcome !

 

[johnwm]

Do you have a reference to the Access Object model in your original project? If so your app will only work on a machine with Access installed.

If you don't want to buy licences for all users then you may need to avoid the use of Access Library in your project by direct use of ADO

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[cbsm]

AS I said, the application is working fine.
The only problem is regarding the datareport that can't be opened.
Anyway, there is no reference to the Access Object in my project.

 

[bjd4jc]

Msdrptr.dll is not the only dll used in a datareport....

For example, C:\Program Files\Common Files\designer\MSDE.dll is also used...

 

[cbsm]

Thanks, that could be the one.
Where could I find the list of all necessary dlls (just so I can check them all at once)?
And why didn't the Visual Package tool not add it in the package ?
(by the way, Access is now installed on this machine, and I still have the problem - so it is not linked to this apparently).

 

[cbsm]

Well, this is what I've done.
I did as suggested on the microsoft web.
I used "Process Explorer" to track all the dlls etc.. I used on my PC.
Apparently those linked to the datareport are :
- msdbrptr.dll
- msderun.dll
- msstdfmt.dll
- msbind.dll

There are all there (in the right place), and registered on the other PC !
But the report still won't open !

Oh, by the way this is the code I use to open the report - maybe there is a clue there :

Public Sub OpenReport(iType As Integer, Ref As String)
On Error GoTo err
Dim PictureLocation As String
Dim strRelated As String
Dim rptData As Object

Set rptData = New DataReport
'get Picture
Select Case iType
Case 5
Set rptData = rptReport1
Case 6
Set rptData = rptReport2
Case 7
Set rptData = rptReport3
End Select


PictureLocation = GetPictureLocation(delphiRef, 0)
strRelated = GetRelated(delphiRef)

If DataEnvironment1.CnnReport.State <> 0 Then DataEnvironment1.CnnReport.Close
DataEnvironment1.CnnReport.ConnectionString = "Provider=MSDataShape.1;Persist Security Info=False;Data Source=" & gobjDB.DataBaseLocation & ";Data Provider=MICROSOFT.JET.OLEDB.4.0"
DataEnvironment1.CnnReport.Open
Select Case FicheType
Case 5
DataEnvironment1.cmdReport1 Ref
Case 6
DataEnvironment1.cmdReport2 Ref
Case 7
DataEnvironment1.cmdReport3 Ref
End Select

Set rptData.Sections(3).Controls("image1").Picture = LoadPicture(PictureLocation)
'related products
rptData.Sections(3).Controls("lblRelatedProducts").Caption = strRelated

rptData.Show vbModal
DataEnvironment1.CnnReport.Close
Set rptData = Nothing
Exit Sub
err:
Set rptData = Nothing
gobjErr.ShowError g_modname & ".OpenReport"
End Sub

 

[cbsm]

Well, Here is what i've done to make my programm work :
I've re-written the code, so that I do not use the rptdata object anymore. And it worked.
(The code is a bit heavy now, but well...)

I still do not understand what was wrong with the previous code, what dll or other I was missing, so if someone has an idea ...