Change Connection String

[shaikhintekhab]

I made a crystal report using Connection String.
Step used was->
Under Database select More Data Sources.
Under that Select Microsoft SQl Server.
Make new connection.

Now my point is how do i change this connections String
Dynamically in my ASP.

I saw the Article at

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/100/spid/766/sfid/540

I have following code
userid = "sa"
password = ""


session("oRpt&quot.MorePrintEngineErrorMessages = False
session("oRpt&quot.EnableParameterPrompting = False

' Set the location
session("oRpt&quot.Database.AddOLEDBSource "Initial Catalog=Database2;Data Source=ACTAEON;User Id=sa;Password=;","Table1"

It gives error

Error Type:
Crystal Reports ActiveX Designer (0x80047288)
Server has not yet been opened.
/aspxmps8/Intermediate/SimpleSetLogOnInfo/SimpleSetLogOnInfo.asp, line 95