RE: sun.jdbc.odbc.JdbcOdbcDriver not supported on 5.1.2 ?

There are other free/low-cost options that would work:
 - Embedded CloudScape (installed in the cloudscape subdirectory of the
   WTE -- pure Java so it's not as fast as a full-blown DB2, but then
   again, it doesn't need to be)
 - Firebird (based on the code that Borland open-sourced for Interbase
   several years ago)
 - PostgreSQL (8.0 beta runs native on Windows)
 - SAP DB

There is one thing worth mentioning about local DB2, if you ever use the
WDSC Data Perspective.  We found that when we installed WDSC 5.1.2, we
lost the ability to work with DB2 UDB for iSeries stored procedures
until we installed the DB2 Application Development Client (which meant
installing the DB2 included in the WDSC disc pack).  This wasn't true
for WDSC 5.1.0, so I don't know if this is a bug or a feature. 

--Robert


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Paul Nicolay
Sent: Wednesday, December 01, 2004 7:14 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] sun.jdbc.odbc.JdbcOdbcDriver not supported on
5.1.2 ?

Hi Collin,

I just did the test, and using WAS 5.0 Express Test Environment does
indeed solve the issue.  My application works again in my test
environment.

Having a real test environment on iSeries is indeed recommended, but not
always that practical when doing some development at home (even while I
have a VPN to our iSeries), and especially when giving demo's to people.

Guess I will finally move to mySQL for this purpose (tried DB2 locally
before, but consider that as overkill).  The risk is that it is indeed
not compatible (but that extra effort improves portability of the
application)... but I noticed that as well with certain things between
the WTE and the actual WAS on iSeries.

Kind regards,
Paul