We have an app in development. The front end of the app is web-based running
tomcat.
This app sits in our DMZ.
This app communicates to a sql 2000 server on our corporate network. The

Using Microsoft JDBC driver, is there any way to set the min, max and
increment number of the connection in the connection pool?
Thanks.
     ds = new SQLServerDataSource();        

I Still have problems.
Now I have two win 2k server, one with IIS and one with Sql Server 2k.
When I try to access from a client with 2k professional i have this error:
Error Type:

I have a problem with SSPI !
I have SQLServer and LAN On the same mashine. They have no connection
between them.
When I try to connect to SQLServer Without LAN He wrote : "Can't Create SSPI

Calling connection.prepareStatement("  "); throws a
NoSuchElementException instead of something legitimate,
like a SQLException.
This is just a simple bug, but since I can't figure out how

I am using the JDBC SP3 driver.  My tables use varchar columns (no Unicode
due to way data is received).  I have set
SendStringParametersAsUnicode=false.  Everything works well except...
Updating a varchar column with byte values sometimes fails.  The code does a

Running SQL 2000 (with blank sa password tut tut!!)on
Windows 2003. On Tuesday all connections to SQL server
failed. Checked ODBC connection and it too failed.
Checked in EM and reset sa password back to 'blank'. All

Situation:
Database server on WinXP SP2: SQLServer2000 SP3
Client machine on WinXP SP2: VB6 COM+ and VB6 client application.
Firewall is disabled on both machines.

I use "SQL Server 2000 Driver for JDBC SP3" to connect SQLServer2000 under
Tomcat App server.
I wish to control the number of physical connections made to the database to
50. Can somebody guide me about this.

I have a user who is attempting to connect to SQL Server Enterprise 2000 SP3a running on Windows 2000 Server.  The client has WIndows NT 4.0 with MDAC 2.8.  The problem is that when I attempt to create the ODBC link , I receive the following error
"connection failed
sqlstate ...

Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle)
directly without having to create a DSN before hand.
This would be great as dumb users can't handle creating a DSN.
Would be nice if I could ask them SQL Server or Oracle, server name, user

 I have a problem. My web server is a Windows 2k Server and my database
server a Windows 2003. I use windows authentication to login at SQL Server,
but when I access from a client machine that uses Win 2k Professional I
always receive this message: "[Microsoft][ODBC SQL Server ...

Having read BOL, I was of the understanding that if a machine was lost
(anything but disk failure) then it was very difficult to recover the data.
The reason being that the data- and log-files were still "attached" to the
dead SQLServer and needed to be detached from it before they ...