SQL Server JDBC - How to set max connections?

Author

How to set max connections?

Frank

2005-07-19, 11:23 am

I'm use class.forName to load SQLServerDriver. If I want to set the max
connections to other than the default, how do I do that?

Thanks,
-- Frank

Joe Weinstein

2005-07-19, 1:23 pm

Frank wrote:

> I'm use class.forName to load SQLServerDriver. If I want to set the max
> connections to other than the default, how do I do that?
>
> Thanks,
> -- Frank

What is 'max connections'? It is not a driver property that I know of...
Joe Weinstein at BEA

Kamil Sykora [MSFT]

2005-07-25, 8:25 pm

Hello Frank,

I think you are talking about the server-side setting called "user
connections". There is no client-side property that you can set to do the
same.

You can configure this value from Enterprize Manager on the Connections tab
or with a
sp_configure 'user connections' statement in Query Analyzer. Please see the
"user connections Option" Books Online topic for more important information
about this setting.

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/secur_ity.

--------------------
| Thread-Topic: How to set max connections?
| thread-index: AcWMfQTydRvRJc6qT2ie
YQQnWcyC1g==
| X-WBNR-Posting-Host: 204.64.62.132
| From: "=?Utf-8?B?RnJhbms=?=" <Frank@discussions.microsoft.com>
| Subject: How to set max connections?
| Date: Tue, 19 Jul 2005 09:15:03 -0700
| Lines: 5
| Message-ID: <39B925FA-078E-4F4C-AD28- 3DA12EF8E20C@microso
ft.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.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.jdbcdriver:1201
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I'm use class.forName to load SQLServerDriver. If I want to set the max
| connections to other than the default, how do I do that?
|
| Thanks,
| -- Frank
|

Sponsored Links