CliffordEvans
asked on
Changing DataSource
I've a number of reports that are currently held on the local database server using OleDB ADO.
Now I need to be to tell each report, at run-time, to go get their data from an identical database but which is on a different server. What is the best way to do this ? Alternatively would it be better to keep a copy of the report locally on each server pointing at their own local database and load the reports remotely ?
Thanks
Now I need to be to tell each report, at run-time, to go get their data from an identical database but which is on a different server. What is the best way to do this ? Alternatively would it be better to keep a copy of the report locally on each server pointing at their own local database and load the reports remotely ?
Thanks
you can write a small application and set the db and server information runtime. If you need help with coding I can help you. what version crytsal, what language u can wriite app with you have to answer us first
ASKER
Crystal 10
VB.NET
Thanks
VB.NET
Thanks
You dont like my c# codes though :)
This might be useful
http://support.businessobjects.com/communityCS/FilesAndUpdates/vbnet_win_samples.exe.asp
mlmcc
http://support.businessobjects.com/communityCS/FilesAndUpdates/vbnet_win_samples.exe.asp
mlmcc
ASKER
mlmcc - agree it is useful but can't find a relevant example.
ebolek - C# is fine - I can convert it.
ebolek - C# is fine - I can convert it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't have VB.Net so I haven't looked at that link in much detail.
mlmcc
mlmcc
ASKER
ebolek,
Do have have code available to do this in VB6 too ?
Thanks
Do have have code available to do this in VB6 too ?
Thanks
ASKER
Just realised it is very similar to .NET.
I dont have vb code. Other experts might have it but the main iodea is the same. If you understand how to do it, it is a matter of time to write it in another language
regards
Emre
regards
Emre
Glad I could help
Regards
Emre
Regards
Emre
ASKER