>>Have an upcomming need to access (and possibly update) data stored in DB2 tables on a IBM Mainframe. There is already considerable data and processing done at the workstation (all in Fox) and the client wants to initially pull down info from the home office. I did some quick research an most of the ODBC/SQL stuff speaks to SQL Server (surprise), then Oracle, and sometimes a mention of Sybase. I have only found one ref to DB2 and it was in an Access 7 reference and was disquieting in that it mentioned the need for an intermediatary gateway to 'arbitrate' DB2's conformance (not compliance) with OBDC standards. Any body done this or get me moving in the right direction?
>>TIA
>>Gary
>
>Have you tried InterSolv
http://www.intersolv.com. They have ODBC drivers for DB2 on IBM mainframes
Thanks all for the replies. I'll try the intersolv site. The tripple threat gateway does sound very IBMish.
I get you updated
Gary
Helping Make Ideas Reality