Link to home
Start Free TrialLog in
Avatar of CliffordEvans
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
Avatar of ebolek
ebolek

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
Avatar of CliffordEvans

ASKER

Crystal 10
VB.NET
Thanks
You dont like my c# codes though :)
Avatar of Mike McCracken
mlmcc - agree it is useful but can't find a relevant example.
ebolek - C# is fine - I can convert it.
ASKER CERTIFIED SOLUTION
Avatar of ebolek
ebolek

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't have VB.Net so I haven't looked at that link in much detail.

mlmcc
ebolek,
Do have have code available to do this in VB6 too ?
Thanks
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
Glad I could help

Regards
Emre