I had created a program using vb6 and SQL Server 2000 as Databae.
For reporting purpose I had used Data Report and Crystal Report 10.
My program is working fine and now I want to run more then one company in one computer for which I had to duplicate my database with another name and change my connection name is my vb6 sofware.
The problem is I had used connection wizard to connect DataReport (DataEnvironmen t) and CrystalReport and when I used the second programe its displaying data from old company.
How can I change the database name? quickly and easily. Should I had to go for each and every report and change the database, as I had too many reports so It will take too much time, Is there any way to do it quickly Like coding someinting in dataenvironment etc
For reporting purpose I had used Data Report and Crystal Report 10.
My program is working fine and now I want to run more then one company in one computer for which I had to duplicate my database with another name and change my connection name is my vb6 sofware.
The problem is I had used connection wizard to connect DataReport (DataEnvironmen t) and CrystalReport and when I used the second programe its displaying data from old company.
How can I change the database name? quickly and easily. Should I had to go for each and every report and change the database, as I had too many reports so It will take too much time, Is there any way to do it quickly Like coding someinting in dataenvironment etc