Trying To Change Server Name

[clydejones]

Hi All,

We are upgrading from Crystal 8.0 Developer edition to Crystal 9.0 (not sure which edition to get (Developer or Advanced)). I'm presently testing with the Advanced edition. Here's the problem. I can't change the server name of the reports in the ASP that makes the connection to the databases of the report. Here's what I'm trying to do in an ASP page:

serverName = "serverName"
dbName = "dbName"
userID = "UserID"
password = "password"
set dbLogon = session("oRpt&quot.Database.Tables.Item(1)
dbLogon.SetLogonInfo cStr(serverName), CStr(dbName), CStr(userID), Cstr(password)

If I physically go and set the location to the correct serverName, everything works fine. Problem with that is there are hundreds of reports. Does anyone have the answer or a suggestion? Help a dude out. Oh yeah, I've downloaded and installed the cr90dbexwin_en hot fix. No changes.

Thanks,
Clyde

 

[psynoff]

Hi Clyde,

I'm way behind you and would like to catch up and try the same thing. I'm a 100% crystal newbie!

What SDK are you using? I've seen mention in the doc of an "Administration SDK" that purports to support this.

Thanks!

 

[clydejones]

psynoff,

Haven't found the answer yet. Don't know anything about "Adminstration SDK". Will have to look into it.

clyde

 

[synapsevampire]

You might need to discardsaveddata, at least in VB you do.

-k