By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,983 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,983 IT Pros & Developers. It's quick & easy.

Where is the connection string stored in a simple Crystal Report

P: n/a
Where is the connection string stored for a simple Crystal Report Application.

What I am trying to do is:
1. Create a simple report from a Firebird database using an ODBC connection
2. Need to compile and deploy to a production environment
3. How to set the data connection so it is can connect to the production
database which is different to the dev database...this must be able to be
done on the production system after compiling on the dev system.

--
Brad
Sydney, Australia
May 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Brad" <Br**@discussions.microsoft.com> wrote in message
news:79**********************************@microsof t.com...
Where is the connection string stored for a simple Crystal Report
Application.

What I am trying to do is:
1. Create a simple report from a Firebird database using an ODBC
connection
2. Need to compile and deploy to a production environment
3. How to set the data connection so it is can connect to the production
database which is different to the dev database...this must be able to be
done on the production system after compiling on the dev system.

--
Brad
Sydney, Australia


1.You can use ODBC data source located in administrative tools in control
panel to create odbc connection.
2.On production system simply create odbc connection with same name and
specify database and server.
3.Or you can create udl file from witch you can connect to database.
4.Or you can create any file like txt or something else,there is many ways
to do it.
May 5 '06 #2

P: n/a
Radenko
Hi. Thanks for the response. I had tried your first suggestion already but
it does not work. Not sure why. I am using a Firebird database and I do know
that the ODBC connection is sensitive to the folder location of the database.
If it is not the same on both platforms I suspect that this is what is
causing the problem.

Please could you give me some pointers on how to use your second and/or
third suggestions. The simplest method would be the best.

Also note that I am new to C# so need to keep things simple. I have
developed the report entirely in the IDE and it works fine so do not want to
do too much additional coding other than changing the database connection at
run time when deployed.

Cheers
--
Brad
Sydney, Australia
"Radenko Zec" wrote:

"Brad" <Br**@discussions.microsoft.com> wrote in message
news:79**********************************@microsof t.com...
Where is the connection string stored for a simple Crystal Report
Application.

What I am trying to do is:
1. Create a simple report from a Firebird database using an ODBC
connection
2. Need to compile and deploy to a production environment
3. How to set the data connection so it is can connect to the production
database which is different to the dev database...this must be able to be
done on the production system after compiling on the dev system.

--
Brad
Sydney, Australia


1.You can use ODBC data source located in administrative tools in control
panel to create odbc connection.
2.On production system simply create odbc connection with same name and
specify database and server.
3.Or you can create udl file from witch you can connect to database.
4.Or you can create any file like txt or something else,there is many ways
to do it.

May 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.