MSDE 2000 sp3a microsoft JDBC & W98

hi
I'm esperiencing a problem within a notebook where I have to run a web
application (I use a TomCat Catalina server). This notebook isn't connect in
a network and don't have a network card in it.
I've set TCP protocol within MSDE via SVRNETCN but I can't run my
appilcation I get an errore like Can't create a pooling connection
The same application with same Hardware + network card run fine.
please help
Gian Claudio
Hello Gian Claudio,
Are you sure the MSDE instance is listening on TCP/IP? You can check that
in your error log. You should see something like:
2005-05-02 14:35:38.48 server SQL server listening on 65.53.8.223: 1433.
2005-05-02 14:35:38.49 server SQL server listening on 127.0.0.1: 1433.
2005-05-02 14:35:38.56 server SQL server listening on TCP, Named Pipes.
2005-05-02 14:35:38.64 server SQL Server is ready for client connections
That tells you which IPs and port the server is listening on.
On a default installation of MSDE you would see something like:
2005-05-03 11:33:20.95 server SQL server listening on Shared Memory.
2005-05-03 11:33:20.95 server SQL Server is ready for client connections
which means it only listens on Shared Memory. The JDBC driver can only
connect through TCP/IP.
Additionally, can you test that you can connect to the SQL Server locally
with Query Analyzer over TCP/IP? You can specify tcp:servername in the
connect dialog to force connecting with TCP/IP. Otherwise you could be
connecting with named pipes or shared memory.
If all that works, can you also try connecting with a simple JDBC
application outside of TomCat and let me know what the exact exception and
full stack is?
Thanks,
Kamil
Kamil Sykora
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/securXity.
| From: "Gian Claudio Bernardi" <poc3796@.iperbole.bologna.it>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: MSDE 2000 sp3a microsoft JDBC & W98
| Date: Thu, 14 Apr 2005 18:27:42 GMT
|
| hi
| I'm esperiencing a problem within a notebook where I have to run a web
| application (I use a TomCat Catalina server). This notebook isn't connect
in
| a network and don't have a network card in it.
|
| I've set TCP protocol within MSDE via SVRNETCN but I can't run my
| appilcation I get an errore like Can't create a pooling connection
|
| The same application with same Hardware + network card run fine.
|
| please help
|
| Gian Claudio
|
|
|
sql

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