Connection

Hi,

Is there any method to find out the database connection in the “BOI USER Module”.

We have a test server and a production server both of which consists of same data. Recently we have changed the connection from test to production. Now I want to ensure that the User module is pointing to the right server.

I changed the connection string in the universe(Designer module)and exported the universe . Do I need to do some changes in the User module too?

Any suggestion is greatly appreciated.
Thx.


Listserv Archives (BOB member since 2002-06-25)

You can create a variable in the reporter which prints the connection string using. For example =Connection(DataProvider()).

Pia G. Thompson
Xenon Consulting Inc.
1010 Northern Blvd, Suite 208
Great Neck, NY 11021
phone: (516) 466-0666
fax: (516) 466-4155
www.xenonc.com


Listserv Archives (BOB member since 2002-06-25)

I created a document and created a cell with a formula in it that displays the ‘TEST’ vs the ‘PROD’ environment. Here is the formula - see if it works for you with some minor tweaking.

=If Match(Connection(DataProvider(<Show Group(Query 3 with MFIExpoR)>)),“regt”) Then “Using Test Database” Else “Using Production Database”

Javed Maqsood
Context Integration

Aravind, G (GEP, Contractor) wrote:

Hi,

Is there any method to find out the database connection in the “BOI USER Module”.

We have a test server and a production server both of which consists of same data. Recently we have changed the connection from test to production. Now I want to ensure that the User module is pointing to the right server.

I changed the connection string in the universe(Designer module)and exported the universe . Do I need to do some changes in the User module too?

Any suggestion is greatly appreciated.
Thx.


Listserv Archives (BOB member since 2002-06-25)

I am currently investigate the impact on changing Business Objects’ connections from synchronous mode to asynchronous mode. It would be highly appreciated if anyone in the list could provide any information on how to decide fetch size to get optimal performance and at same time to get rid of “fetch out of sequence” error.

If somebody can also provide any information on what are the benefit of keeping connection for all the session or disconnect after each transaction, that will be great help.

We are on Business Objects 4.1 and Oracle 7.3.

Thanks in advance for any information.

Hefeng Huang


Listserv Archives (BOB member since 2002-06-25)