AS400 - Connection from ReportNet

[spicysudhi]

Hi

I am facing problem in conencting IBM AS400 from ReportNet. The datasource creation is successful, connection testing succeeded. When I select the datasource in FrameworkManager, I get error message "[IBM] [Client Access Express ODBC Driver (32-bit) invalid table type ignored.".

{Using the same ODBC connection, I am able to connect in Impromptu and import the tables.}

help from anyone,,,?

thanks,
Sudhi

 

[Recce]

Hi sudhi8645,

what version of Client Access / AS/400 operating system do you make use of and also what is the version of your Access Express ODBC Driver (32-bit) drivers in ODBC that you use (this is the .dll version )

 

[goldsmt]

I found that i had to use Version 8 of the Client Access ODBC driver to get report net to work.

The HIT ODBC driver and DB2 connect also work and may prove to be a more stable solution

Regards

Tony Goldsmith