Yes,
use the
CRDatabasetable.SetLogOnInfo dnsname, databasename, uid,pswd
to changed the data base at runtime. I have got this to work as long as you are linking to tables. I have not been successful getting this to work with stored procedures though.
Kevin Masek
KWorks, LLC
kmasek@execpc.com
Yes. The stored procedure exists on both servers. According to the documentation, I should be able to change the source server using SetLogOnInfo.
All reports except one execute one or many stored procedures. That seems to be my problem. However, it is supposed to be possible.
Kevin...
Mr. Fowler,
Thanks for your response. We are accessing Sql Server natively. There is no DSN name
We have one report that is linked directly to tables. If I change the server name and db name using the following
CRDatabasetable.SetLogOnInfo session("gbldbserver")...
I am using crystal reports 7 inmy asp site.My reports are working fine however....
After development, it is time to move the reports to the production server. Currently, because of the reports, we have three different sites because of the way crystal reports works (ie. a report is linked...
I am using crystal reports 7 inmy asp site.My reports are working fine
however....
After development, it is time to move the reports to the production server. Currently, because of the reports, we have three different sites because of the way crystal reports works (ie. a report is linked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.