Link MS SQL server dynamically

[ahhuang]

I am using crystal report control to link vb & crystal report.
In my crystal report development, I used database "a".
however when i try to load the report using vb, my database is "b", n it loads database "a" data.
please advise why is this the problem and wat are the solutions.
Here are my coding:
cr1.ReportFileName="c:\db\sample.rpt"
cr1.LogOnServer "p2ssql.dll","servername","b","sa",""
cr1.action=1

thanx

 

[IT2003]

In Crystal report, go to the Set Location menu and select the table, and remove the database reference to the table.

Now this rpt should work either you connect to Database a or Database b.

 

[ahhuang]

initially the provided solution provided by IT2003 works, but then recently i changed server n then my crystal report cannot run in VB again.
The message is "cannot open server", even i pass the server name as a variable name.
How can I solve this?