473,388 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

VB6 changing database

284 100+
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 (DataEnvironment) 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
Jan 2 '12 #1
0 1019

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Steven Buroff | last post by:
Is there any way to get MySQL to create the directory for a new database in a specified directory instead of its "data" directory?
4
by: Bruce | last post by:
I need to create a stored procedure in the master database that can access info to dynamically create a view in another database. It doesn't seem like it should be very hard, but I can't get it to...
0
by: munish | last post by:
I m using pull model to retrieve records in crystal reports. Is there any way that i can change login information, database and table at runtime(in .Net).
0
by: Robert OShea | last post by:
Currently we are running a system on old HP box running Turbo Image, this is being phase out and there is some debate over when the Databse should be redesign to run SQL server. We are writing a 3...
0
by: Deano | last post by:
Is there a little stand-alone utility in existence that could change a database password? I'm thinking of situations where perhaps I'm working on a machine which lacks Access. It could prompt for...
1
by: Demola | last post by:
Hi all, I am developing a VB2005 Program with MS Access and CrystalReport. I need to make the report to acces the Database from a different machine after deployment, how do I achieve this? ...
3
by: Richard Hollenbeck | last post by:
Hello, I just moved my main database and the backend database to a better location and changed the name. But now I can't seem to get Access to recognize the new location and name. I tried using...
1
by: joey0714 | last post by:
I have a Crystal Report that I need to change the database location during runtime. Does anyone know how to do this? I have tried different ways and they all have errors. Here is a copy of my code: ...
0
by: michael ngong | last post by:
pramod@rtimes.com (Pramod Ramachandran) wrote in message news:<6616e304.0306240122.4dd3ecd5@posting.google.com>... Permit me start with the second question. It would be easier to be more...
2
by: hmznzr | last post by:
i am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.