AS400 ODBC driver

"Art" <artbarrios@hotmail.com> wrote:
>
>I have a client who needs to connect to a standard AS400 database through
>ODBC. I know nothing about AS400s. Is there a "standard" AS400 database,
>is it DB/2? What you you need to connect using ODBC in Windows?
>
>Thanks.

You could use DB2 Connect as middleware. DB2 Connect comes with something
called
the run-time client that contains the DB2 ODBC drivers. See http://www.software.ibm.com/data/db2connect

You can use OLEDB providers too, their performance is better than ODBC drivers.

IBM offers an OLEDB driver with their product Client Access Express, Microsoft
offers a product called Host Intergration Server that also has an OLEDB provider,
there is a company called HIT Software that makes the best of them all, at
least is the only one that i could get to work with some strange RPG stored
procedures in an AS400.

Hope it helps.

Greg Nash <gnash@namoicotton.com.au> wrote:
>hi,
>AS/400 Client Access and C A Express both have a fairly capable ODBC driver;
if they
>client already uses CA
>then you have what you need.
>Otherwise, yes, DB2 Connect will do it.
>There are minor implications on the AS/400 end for configuration, etc and
which subsystems
>/ services are
>running, but it's not too hard either way.
>
>Larry wrote:
>
>> "Art" <artbarrios@hotmail.com> wrote:
>> >
>> >I have a client who needs to connect to a standard AS400 database through
>> >ODBC. I know nothing about AS400s. Is there a "standard" AS400 database,
>> >is it DB/2? What you you need to connect using ODBC in Windows?
>> >
>> >Thanks.
>>
>> You could use DB2 Connect as middleware. DB2 Connect comes with something
>> called
>> the run-time client that contains the DB2 ODBC drivers. See http://www.software.ibm.com/data/db2connect
>