Can anyone help me I want to know if I have to connect to a remote DB2 database using reporting server, do i need to configure a remote server or only DB2 adapters will suffice.
The situation is given below

reporting server------ DB2 server1
|
|
DB2 Server2

DB2 adapter is sufficient. After created that adapter, did you run some test report?

quote:

Originally posted by Kamesh:
DB2 adapter is sufficient. After created that adapter, did you run some test report?

Hi Kamesh,
Connecting to DB2 database on the same machine having reporting server is not problem.Reports are working. But if want to connect to DB2 database on some other machine . Do I need to configure some other things also. since while creating synonyms it asks for Datasource name only and userid.

When you are trying to connect to DB2, you need to have the DataSource name, userid and password to connect.
These things you can set when setting the DB2 connection or you can modify by going in to properties.

Hi Anubha,

Not sure which release of WebFOCUS you are using. For general instructions regarding configuring DB2 Adapter, the following document may be of interest:

Using the Adapter for DB2
http://documentation.informationbuilders.com/masterinde...71/dbdb2.htm#1272851

Hope this helps.

Cheers,

Kerry