Jade to DB2 via ODBC

Discussions about design and architecture principles, including native JADE systems and JADE interoperating with other technologies
ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Jade to DB2 via ODBC

Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:12 am

by Leigh Roberts >> Thu, 3 Dec 1998 3:01:28 GMT

We have a requirement to read DB2 tables from Jade. ODBC is the immediate solution but it is not currently one of the supported databases. However it is highly likely to work according to well informed sources .

Has anyone tried it?

Leigh

also posted on internal news group.

ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Re: Jade to DB2 via ODBC

Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:12 am

by Leigh Roberts >> Thu, 17 Dec 1998 3:17:19 GMT

I have now done this myself. I've just done simple selects but I can assume that the rest of it would work. It was as easy as I anticipated.

I picked up a copy of DB2 Universal Database and installed it no probs, just takes a while.

First step is to include the sample database in your ODBC arsenal in the usual way.

Load the ODBC extensions into Jade.

Set up an External database with the wizard.

Write some methods - it works first time.

DB2 looks to have some nice management tools too.

Leigh

ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Re: Jade to DB2 via ODBC

Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:13 am

by Paul Mathews >> Wed, 16 Dec 1998 20:53:04 GMT

We have done a lot of work with ODBC, to communicate with DATAFLEX and using the ODBC drivers directly never fully worked, reading was pretty
ok except for large tables. But updates, adding and deleting was
pretty hard.

The solution was to connect to Access Queries made from Tables linked
to the DataFlex tables.
Not an obvious approach.

Try the odbc drivers first, but if you get desperate try the above.

We will be updating our odbc whitepaper on our page soon, with our
latest experiences.


Return to “Design and Architecture”

Who is online

Users browsing this forum: No registered users and 3 guests