I use SQL Sever 2005 as my database. I need to change my db connection, right now my current reporting environment is pointing to UAT i need to change it to PRODCan any one help me out where and how is this configuration done?. And how the can be created and modified.

This message has been edited. Last edited by: Kerry,

Use the webfocus server console page to configure your SQL 2005 connections.

When that is done, there are two ways (at least) to select which environment to query.
The first is to, at the point where you have to decide which environment to query, issue the command to select the connection:
ENGINE engine_name SET DEFAULT_CONNECTION connection_name
You would need master/access files in which no connection name is recorded to have this work correctly.

The second is to have a separate set of master/access files for each environment. You would then need to set the application path for the enviroment to use, so that it points to either the UAT set of master/acces files, or to the PROD set.

Hope this helps ...

If it is not already done, you also need to add that neww connection using your Data Sources tool. That let's the WF client know that there is an additional source available that will use the SQL Server Client. If you simply replace the old connection with the new one (same name , dbname, tables, etc.) you should not need to make any changes in WF. If connection name, dbnames, table names, or column names/formats have changed, you will need to regenerate your master and access files as GamP describes.

Thanks Guys.. For the replies..
But still im nt able to create connections or metadata for my MRE what could be posb reason for this ???.I have been able to do that in the EDASERVE envinronment.Can u lemme knw abt the creation of metadata and connections in the MRE.
TIA

If you have the connection made in your edaserve environment, then it is also avialable in mre. There's no seperate edasprof for mre, it all goes through the same file. So if you want to have the prod connection to be default, edit your edasprof file and place the prod connection string first in the list. That will make it the default connection.
Outside of MRE you can choose which connection to use, but from inside MRE the default will now be the prod connection.

and where does this edasprof file reside??
on the webfocus reporting server or the local machine??.And how to edit this file if it resides on the WF server.Thats what i have not been able to do.Can you help me on this.

Your edasprof.prf would reside in this directory: /WebFOCUS/ibi/srv71/wfs/etc, or something close to that.

You can set up your data base connections using the Data Adapters menu of the reporting server console whose URL should be something like this: http://your_web_server:8121. If you are not using the standard port number, you can look in the odin.cfg file which is in the same directory as the edasprof.prf file.

You can create and test the connection right from that screen before you try running any focexecs.

You can even edit your edasprof file from within the server console pages.
It is under 'Workspace', 'Configuration', then click open 'Configuration Files', 'Server Profiles'. And there it is, your Server Profile. Just click on it and can edit it.

Hope this helps...