clydejones
Programmer
Hi All,
My company is switching from Crystal 8 to Crystal 9. The reports used in our ASP application can connect to one or more databases. With Crystal 8, our ASP application worked fined with all reports not matter how many databases were used to build the report. Now with Crystal 9, the application appears not to be able to connect beyond the first database. Therefore not running the report. I also noticed this in running the reports from Crystal 9. This version wants me to login to each database, but with version 8 all I needed to do was to login to the first database. Is there a setting or something I can set to fix this? Below is the code I'm using to login to the database.
'***************************
serverName = "ServerName"
dbName = ""
userID = "userID"
password = "passWord"
set dbLogon = session("oRpt"
.Database.Tables.Item(1)
dbLogon.SetLogonInfo cStr(serverName), CStr(dbName), CStr(userID), Cstr(password)
'***************************
As I said before, this worked fine with Crystal 8 no matter how many databases I used for the report. This code doesn't work for Crystal 9. I also tried setting another "Item". I need HELP.
Thanks In Advance,
Clyde
My company is switching from Crystal 8 to Crystal 9. The reports used in our ASP application can connect to one or more databases. With Crystal 8, our ASP application worked fined with all reports not matter how many databases were used to build the report. Now with Crystal 9, the application appears not to be able to connect beyond the first database. Therefore not running the report. I also noticed this in running the reports from Crystal 9. This version wants me to login to each database, but with version 8 all I needed to do was to login to the first database. Is there a setting or something I can set to fix this? Below is the code I'm using to login to the database.
'***************************
serverName = "ServerName"
dbName = ""
userID = "userID"
password = "passWord"
set dbLogon = session("oRpt"
.Database.Tables.Item(1)dbLogon.SetLogonInfo cStr(serverName), CStr(dbName), CStr(userID), Cstr(password)
'***************************
As I said before, this worked fine with Crystal 8 no matter how many databases I used for the report. This code doesn't work for Crystal 9. I also tried setting another "Item". I need HELP.
Thanks In Advance,
Clyde