Newbie wants to connect VB.net to AS/400 DB2

C

chairyuan

Newcomer
Joined
Aug 14, 2003
Messages
7
Location
Atlanta, USA
Looks like I have a million questions.

I'm running VS.net. I try to connect to an AS/400 database.
I drag the OldDbDataAdapter, then the Data Adapter Configuration wizard pops up. I choose New connection.

I want to connect to a DB2 database on AS/400 (iSeries), so I choose 'IBM DB2 UDB for iSeries OLE DB Provider', entering IP address on the server name text box, enter the user name, add the library I wants to access in default collection, test Connection - succeeded.

Using Query Builder, it shows all the table (physical file) and view (logical file) in the library. I select the 'temp' table, select * (all columns) - SELECT MYLIB.TEMP.* FROM MYLIB.TEMP.

Now, next to View Wizard Results. Error:
Generated SELECT statement. Failed to get schema for this query.

What cause that? Does iSeries has to has the SQL package installed?
 
No, it's because (in my opinion) IBM can't bring themselves to make something compatible with the rest of the planet.

Your query should look like this => SELECT * FROM MYLIB."TEMP"

For some idiotic reason, that's the only way I can access specific tables
 
Back
Top