| |
ActiveReports 2.0 (Visual Basic 6.0) Support
Started by joer1998 at 02-12-2010 9:33 AM. Topic has 6 replies.
  
|
|
Sort Posts:
|
|
|
|
 02-12-2010, 9:33 AM
|
joer1998
Joined on 02-25-2009
Columbus, OH
Posts 42
|
Active Reports PDF Export DLL Error
|
|
|
|
|
Receiving the following error when trying to run our Active Reports. Current server configuration is Windows 2008 R2, ActiveReports 2.0. This error is found in our IIS log file
|70|80004005|ActiveReports_PDF_export_DLL_error_Pages_collection_contains_0_pages.__Export_Fails
set arptserver = server.CreateObject("reportserver.rptserver")
set aDBserver = server.CreateObject("reportserver.dataprovider")
Line 70 = vRpt = arptserver.ExportToByteArray("PDF",adbserver)
Now I should mention that I know that AR 2.0 works in this configuration because we have another server setup exactly the same and the reports work just fine.
Wondering if you could point me in the right direction to get these reports working. I have commented out most of the lines to generate the report in the asp page and just printed the Recordset results, so I know it is reaching the database and returning data just fine as well.
Is it a folder permissions based thing? I don't recall what I did to get it to work on the other server.
|
|
|
|
|
Report
|
|
|
|
|
02-12-2010, 11:06 AM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
Hello,
The error mentions that the page collection contains zero pages. Have you run the report before making the export?
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
02-12-2010, 12:04 PM
|
joer1998
Joined on 02-25-2009
Columbus, OH
Posts 42
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
This code works fine in production. I should mention this new server configuration is 64-bit.
Here is the code
set rs = PM_Con.execute(sQuery)
IF rs.recordcount <> 0 then
' Format parameter to pass to report
param1 = MonthName(month(Request("cycle_date"))) & " " & day(Request("cycle_date")) & ", " & year(Request("cycle_date"))
oDic.Add "runForDate",param1
adbserver.Parms = oDic
adbserver.Debugging = false
arptserver.Debugging = false
adbserver.ConnectionString = strConnection
adbserver.SQLstatement = sQuery
arptserver.IsUnbound = true
arptserver.RPXInputPathAndFileName = Server.MapPath("stmt_financial_condition.rpx")
vRpt = arptserver.ExportToByteArray("PDF",adbserver)
Response.Clear
Response.ContentType = "application/pdf"
Response.BinaryWrite vRpt
|
|
|
|
|
Report
|
|
|
|
|
02-16-2010, 12:11 AM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
Hello,
The problem is because you are using the ActiveReports 2.0(COM/VB6) dll in a 64-bit environment. Please take a look at this Forum, where the issue is discussed.
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
02-16-2010, 6:56 AM
|
joer1998
Joined on 02-25-2009
Columbus, OH
Posts 42
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
Prantik,
Thanks for the reply. What I gathered from those posts was that we are talking development of the reports. Which would make sense that the VB6 IDE is not supported on 64-bit environments.
We have two identical Windows 2008 servers. Active Reports on both servers. One server the reports work perfectly. The other one they do not. So it is possible for AR 2.0 (COM/VB6) to run in this environment. Just trying to determine what I may be missing on the other server that won't allow them to work.
Thanks
|
|
|
|
|
Report
|
|
|
|
|
02-16-2010, 9:42 PM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
Hello,
The problem here is that ActiveReports dlls are 32 bit and you are running the same in a 64-bit machine. Where have you placed the ActiveReports dlls in the 64-bit machine? Try placing them in the Syswow64 folder (c:\windows\syswow64). Then, register the same from the command prompt after having browsed to the syswow64 folder. I am able to make run ActiveReports and make the relevant exports in my testing using this approach. Please take a look at this Microsoft article in this regard.
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
03-09-2010, 8:03 AM
|
joer1998
Joined on 02-25-2009
Columbus, OH
Posts 42
|
Re: Active Reports PDF Export DLL Error
|
|
|
|
|
|
Sorry for the delay in responding. Only recently have I gotten back to this project.
The problem is solved. ActiveReports was installed in the /program files (x86) folder and so was the custom dll that was created to pass the data connection information onto AR.
Problem ended up a connection string issue, that was being passed into the custom dll in conjunction with AR 2.0
Thanks
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports 2... » Active Reports PDF Export DLL Error
|
|
|
|
|