I recently upgraded from SQL 2000 to 2005 and I am no longer able to use the iseries odbc(V5R3M0). I can see it in my windows odbc session but not when I try to import data in SQL. I have tried the IBM OLE connection in SQL but this does not allow me to see the library, tables or fields on the 400. I have to know what is on the 400 tables and write a query, instead of simply downloading a table from the those listed.
Any help would be appreciated.