MSDE + JDBC SP3 - Run Together in WS

I have a java application running with JDK 1.3.1. I`d like connect this
application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
Service Pack 3, both are free ). Is it possible.
Txs in advance,
Jose R Castro / MCP W2K
| Thread-Topic: MSDE + JDBC SP3 - Run Together in WS
| thread-index: AcTXTYaW1R/kc6+DROSEIv2/byEYnw==
| X-WBNR-Posting-Host: 201.1.124.200
| From: "=?Utf-8?B?Sm9zZSBSIENhc3Rybw==?=" <Jose R
Castro@.discussions.microsoft.com>
| Subject: MSDE + JDBC SP3 - Run Together in WS
| Date: Tue, 30 Nov 2004 18:29:04 -0800
| Lines: 7
| Message-ID: <0EF992D0-735C-439E-B581-A6FA4464B99A@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6519
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I have a java application running with JDK 1.3.1. I`d like connect this
| application through the SQL DB ( MSDE + SQL Server 2000 Driver for JDBC
| Service Pack 3, both are free ). Is it possible.
| Txs in advance,
|
| Jose R Castro / MCP W2K
|
|
Yes, you can connect to MSDE from JDBC in the same way that you connect to
a full-blown instance of SQL Server..
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

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 indicat
e
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

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

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