Sunday, March 11, 2012

Active Data - binding recordset not working

I have converted some reports to read TTX files (from OLEBD), and then changed the 'runReport' page to discard data, and 'setprivate' data (see below). This works beautifully in the test enviroment, but not on our production servers (windows 2000). Its Crystal 8 on all servers.

If any one has any idea... or needs me th explain in more detail... your help would be appreciated!!!How did you run on production?
Did you create set up and installed there?|||Yes - I copied over the TTX files, the associated report files, and the modified ASP pages to the live web servers. By the way, here is the code used on the ASP pages that binf the active data to the report:

rs.Open "SELECT * from table1",cn,adOpenForwardOnly

set session("oRs")=rs

'Attach to report file, and then reassign data from recordset to it
Set Database = session("oRpt").Database
set Tables = Database.Tables
set Table1 = Tables.Item(1)

session("oRpt").DiscardSavedData
Table1.SetDataSource session("oRs")

No comments:

Post a Comment