I currently have a CR that is called from an ASP page that uses a DSN. Here is the code:
set objTable = Session("oRpt".database.tables.item(1)
objTable.setlogoninfo "DSNName","DBName","userid","password"
This works fine, but I would like to use a DSN-less connection. My question is how do I get the report to see the database? I saw the following code in the sample apps that came with CR:
Table1.SetPrivateData 3, session("oRs"
I don't want to use a specific Recordset though. Any ideas?
Thanks,
Paul
set objTable = Session("oRpt".database.tables.item(1)
objTable.setlogoninfo "DSNName","DBName","userid","password"
This works fine, but I would like to use a DSN-less connection. My question is how do I get the report to see the database? I saw the following code in the sample apps that came with CR:
Table1.SetPrivateData 3, session("oRs"
I don't want to use a specific Recordset though. Any ideas?
Thanks,
Paul