DATABASE USER INDEPENDANT

[aomara]

I wander if any one can tell me how to make the report
Independent from the database name or database user name
I have allot of reports that I have to validate it (set
Location for all tables in each report with the ODBC new Database user) when I change
The database name or database user name.
I am using Crystal Reports 9 and
The database can be Oracle, Microsoft SQL Server or Access
Please If you do so, Provide me with how to do it ??

 

[Turkbear]

Hi,
For the database login/password we use a username that has read-only access to selected Oracle tables ( those used for reporting on non-confidential data ) - That way we never have to change that part when changing the actual instance the report connects to ( any Oracle instance that contains such data, for instance our development and production Data Warehouse instances, has that username/password set in it).

We change the connection, if needed, ( say we move the database instance to a new server) by changing the configuration of the alias in the tnsnames.ora file on the CE server ( all our reports use Oracle as a data source, which makes administration much easier).

For other databases this will be more difficult, since the metadata and structure of the datasource will likely be different and will require a 'validate database' step to reset it when changed.

 

[aomara]

Hi
Thank you Turkbear for replay.
The point is that in oracle you are dealing with a connection string which contain all data (Database instance & server name), so if you make the connection string always with the same name, you hane NO problem.
But what about SQL server or Access.
I want to make an adjustment in the report itself so the report can work in any database type and under any database user name .

 

[Turkbear]

Hi,
That may cause you more problems than it will solve.
Every time that report acceses a new datasource it will require that the database be verified before it will work...


One way to try is to build an ODBC DSN and change IT when you want it to 'point' to some other datasource..