Reports CR 8 to CR 9

[newspalm]

Hello, All

presents:
- old reports (CR 8.5)
- CR 9
- MS SQL 2000
- MS IIS 5 (W2K)
- RAS is not installed

My steps:
1. Open old report in Report Designer (CR 9),
Set Datasource Location (choice ODBC "LocalServer1", Database "DB1&quot.

Show SQL Query display:
SELECT "r"."f1", "r"."f2" FROM "DB1"."dbo"."r"

Good. Make preview, save report.

2. Call report from report.asp and set:
Session("SQLUserName&quot = "sa"
Session("SQLPassword&quot = ""
Session("CRDSN&quot = "LocalServer1"
Session("SQLDatabase&quot = "DB1"

Set mainReportTableCollection = Session("oRpt&quot.Database.Tables
For Each mnTable in mainReportTableCollection
With mnTable.ConnectionProperties
.Item("user ID&quot = Session("SQLUserName&quot
.Item("Password&quot = Session("SQLPassword&quot
.Item("DSN&quot = Session("CRDSN&quot
.Item("Database&quot = Session("SQLDatabase&quot
End With
Next

3. All is ok

4. Call this report for other Database (use report.asp)
Session("SQLUserName&quot = "sa"
Session("SQLPassword&quot = ""
Session("CRDSN&quot = "LocalServer2"
Session("SQLDatabase&quot = "DB2"

5. Report is displayed, but all records from "DB1" (need "DB2"!)


How i can change Database source in asp?
What is wrong?

Please, help to me

Best regards, Maxim

 

[synapsevampire]

From the CD whitepaper below:

Within the ASP application, adding the following line of code ensures that the correct database will be accessed and the correct data returned:
crtable. location = "newdbo.dbo.tablename"

http://support.crystaldecisions.com/library/kbase/articles/c2009481.asp

-k

 

[newspalm]

it is right for CR8.
but for CR9?