MSDE & JDBC

I'm trying to find out if there is a JDBC driver for MSDE. Nothing seems to
explicitly state there is however I do see postings which indicate that the
service pack that includes the JDBC driver for SQL Server 2000 will work for
all versions of SQL Server but then I see another post that seems to indicate
only Standard and Enterprise versions and doesn't mention MSDE.
Can you please tell me if there is a driver and how I would go about finding
it?
Thanks."LeeGuth" <LeeGuth@.discussions.microsoft.com> wrote in message
news:D9BA5CC4-D810-413A-985A-CCB086A4B3A0@.microsoft.com...
> I'm trying to find out if there is a JDBC driver for MSDE. Nothing seems
> to
> explicitly state there is however I do see postings which indicate that
> the
> service pack that includes the JDBC driver for SQL Server 2000 will work
> for
> all versions of SQL Server but then I see another post that seems to
> indicate
> only Standard and Enterprise versions and doesn't mention MSDE.
> Can you please tell me if there is a driver and how I would go about
> finding
> it?
>
Even if Microsoft's JDBC driver works, it's not licensed for use with MSDE,
and redistribution is prohibited. The MS JDBC driver is a free download for
owners of Sql Server Standard or Enterprise Edition. Not for developers of
applications targeting MSDE.
There are a couple of free opensource jdbc drivers for Sql Server, which
should work for msde.
Check out:
http://jtds.sourceforge.net/
Or there are several commercial jdbc drivers for Sql Server.
David