DS - Reporting Assistant

Srilaja · Post by **Srilaja** » Wed Sep 25, 2002 1:35 am

Hi,

When I'm trying to execute the 'Reporting Assistant', getting the following errors.

1. Run-time error '429'
ActiveX component can't create object

2. Run-time error '440'
Automation error

Is it necessary to have 'MS-Access' installed in our client work station?

Could you please tell me how to fix the same?

Thanks & Regards,
Srini

srinivasb · Post by **srinivasb** » Wed Sep 25, 2002 2:45 am

Hi,

When I'm trying to execute the 'Reporting Assistant', getting the following errors.

1. Run-time error '429'
ActiveX component can't create object

2. Run-time error '440'
Automation error

Is it necessary to have 'MS-Access' installed in our client work station?

Could you please tell me how to fix the same?

Thanks & Regards,
Srini

Hi,

Have you used the update button.?
You can create the repo tables on SQL server/Oracle ...
You can use MS Access as default
YES,It is needed to have MS Access on your machine.
Regards
Srinivas.B

Srinivas.B
India
Mobile :0091-44-2301101
Xtn 35

Srilaja · Post by **Srilaja** » Wed Sep 25, 2002 5:45 pm

Hi Srinivas,

Good on you.

I will try to generate the reports using ORACLE.

Thanks again.

Regards,
Srini

ray.wurlod · Post by **ray.wurlod** » Sun Sep 29, 2002 7:04 pm

For any database other than MS Access, there is a small amount of setting up to do. In the Documentation Tool folder (typically under AscentialDataStage) on your client machine you will find script files for creating the necessary tables, etc., in other databases - for example oracle.sql, mss.sql, universe.sql. You need to execute these in the appropriate database.
You also need to configure an ODBC connection from the DataStage machine to that database. The default installation for MSAccess uses DSN of "DSReporting"; you can use any name.
When exporting from DataStage Manager into the documentation tool's database, choose Options tab and specify your particular DSN.