ODBC/AS400 (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 06 AUG 1998 03:16:05PM Mike Fasano wrote:

OpenInsight Specific

Everyone,

   I am in need of assistance with an ODBC conneciton for the AS400. I have successfully connected to the 400 and am able to run queries off of the AS400 files. Here is my problem: In the ODBC configuration (Control Panel) I listed the 400 libraries that I wish to access. In OI when I list objects, it shows me all the libraries that I have configured the connection for. However, it will only allow me to query on the first library. The error message returned is (IBMClient Access ODBC Driver (32-bit)DB2/400 SQLSQL0204 - WMPRICF in DATAIP type *FILE not found.)  Any and all help would be greatly appreciated.

                                      Thank You,

                                         Mike

At 07 AUG 1998 07:46AM Cameron Revelation wrote:

Mike,

Could you clarify a couple of things.

I am in need of assistance with an ODBC conneciton for the AS400. I have successfully connected to the 400 and am able to run queries off of the AS400 files.

Do you mean you connected via another tool or within OpenInsight?

Here is my problem: In the ODBC configuration (Control Panel) I listed the 400 libraries that I wish to access.

Is a "library" equivalent to a "table" or "database" or something like that? I am not used to the term.

In OI when I list objects, it shows me all the libraries that I have configured the connection for.

So you have one connection defined to the AS/400 and it has 400 tables available? And they do list correctly in OpenInsight?

However, it will only allow me to query on the first library.

… meaning the first "table" in the list.

What happens if you list the columns (double click on a table when you list objects).

The error message returned is (IBMClient Access ODBC Driver (32-bit)DB2/400 SQLSQL0204 - WMPRICF in DATAIP type *FILE not found.) Any and all help would be greatly appreciated.

Can you try another front end (perhaps the MS Query that comes with office) to see if the problem is unique in OpenInsight?

Also, are you qualifying the table name? Perhaps it needs an owner or qualifier (those first two columns in list-objects).

Cameron Purdy

Revelation Software

View this thread on the forum...