471,066 Members | 1,313 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Where is the connection string stored in a simple Crystal Report

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
2 3947

"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
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.

Similar topics

reply views Thread by Meral Agceli via .NET 247 | last post: by
reply views Thread by Atif | last post: by
reply views Thread by bonita | last post: by
4 posts views Thread by yin_n_yang74 | last post: by
reply views Thread by leo001 | last post: by

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.