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

[chairyuan]

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?

[laredo512]

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