>>>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:

I have heard that version 5 of DB2 will be/is ODBC compliant and the need for the client-side gateway is eliminated. I did quite a bit of research on this for a project I am currently working on. I got valuable information from an IBM DB2 Technical Support guy in Toronto (Bob Harbus - bharbus@VNET.IBM.COM). Their ODBC drivers ship free with their CAE client code (Client Enabler). The server also has to be configured.

I will attempt to e-mail you an additional message with more information than you would probably ever want to know. I am new to this Universal Thread and am in the process of getting my "Premier" membership, so I am not familiar enough to know if I can "upload" this information to this forum.

HTH & Good Luck!

Mark