Where is the connection string stored in a simple Crystal Report

[Guest]

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.

 

[Radenko Zec]

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.

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.

 

[Guest]

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