ODBC driver to AS/400

First, I don't really know much about AS/400, but I need to access a AS/400 database (not a DB2 database, but the "default" database installed with the operating system) from a windows environment. I would like to use ODBC. Does anyone know about any good, cheap, reliable ODBC driver capable of handling this?

Thanks.
ppfAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
0
 
TimCotteeHead of Software ServicesCommented:
Use the client access driver, obtainable from IBM, you should be able to get this from the IBM website.
0
 
cymbolicCommented:
I support our migration services and we have had the best experience with the HIT Software HS ODBC/400 driver.  You can find them on the web at hit.com
0
 
cymbolicCommented:
I support our migration services and we have had the best experience with the HIT Software HS ODBC/400 driver.  You can find them on the web at hit.com.

Once you get a driver like this installed on your system, you can easily examine the tables and data on a 400 database using MS Access by either liniing tables or importing data.
0
 
viscontiCommented:
I have a problem when I try to connect as400 table with ACCESS2000.
I have installed necessary router as400 and driver nsodbc, so i have proceded to import
as400 table in access2000 file's choosing nsodbc file created in Administration of ODBC in winnt control panel .
I receive the general error code -7756.

Can I know what about this error ?

Saluti
FAbrizio Visconti
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.