Post by Von A Schole » Fri, 11 Sep 1998 04:00:00

I'm in need of a DB2 ODBC for use in InterDev.  Do I need buy InterDev 6
to get it or is it out on the web for downloading?

Thanks for your help!


LMITCO                       phone: (208) 526-0590
PO Box 1625                    fax: (208) 526-0454
Idaho Falls, ID  83415-3539


1. DB2 ODBC error

Hello Jassim,

I can't understand why everybody always wants to use ODBC to
connect to an AS/400 DB/2-database.

IBM has an OLE DB provider for this, that is included in CA for

But keep in mind, when using OLE DB provider from IBM that
the creation of the update, insert and delete-statements will fail,
because the way MS creates that statements is incompatible with
the statements used by SQL400 (the AS/400 SQL language).
So uncheck the creation of those three commands (in advanced
in the connection wizard), because they simply do not work.
You can create those statements yourself, and if you ever find out
HOW, please let me know, cause i got stucked there also.

Anyway, to avoid those problems mentioned above, use the old
style ADO instead of ADO.NET until MS or IBM has a fix for
this, you're warned :-) The old style works perfect, but uses
recordsets instead of DataSets.

Hope this helps.



2. How to make my hp 545 remember more?

3. Urgent requirement for DB2 Mainframe administrator (DB2 for z/OS DB2 DBA)

4. Kahaner Report: Computational Physics Parallel Computer, CP-PACS

5. Slow odbc and oledb connection to db2 database

6. IEC standard referenced in DICOM Supplement 11

7. accesing db2 thru ODBC

8. Stardock Fixkit3 problem

9. ODBC.NET to connection DB2(7.0) on AS400

10. Differences between System.data.odbc and Microsoft.data.odbc

11. ODBC.NET - system.data.odbc - VS.net Beta 2 SP2 - Q310985

12. ODBC.NET DATA PROVIDER (Beta1) Not working => System.Data.Odbc not unknown