How to set max connections?

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
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
|||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/securXity.
| Thread-Topic: How to set max connections?
| thread-index: AcWMfQTydRvRJc6qT2ieYQQnWcyC1g==
| 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@.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.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
|

How to set celldata and Permissions to Role

Hi All,

I know how to create a role and adding Members(users) to that role by using AMO class library,but i need some sample code like how we can set the database permissions to the role and how we can set the celldata to that particular role.If any one knows about this please send reply immediately.

it is very urgent.

Thanks in advance.

Hi,

I believe the Adventure Works sample AMO application has code for creating permissions (search for CubePermission or DimensionPermission in the code):

http://msdn2.microsoft.com/en-us/library/ms160736.aspx

In general, you can use this 'reverse engineering' trick to get AMO code:

- create the objects you want with the user interface (in BI Development Studio with wizard/editors or in SQL Management Studio); in this case, use the security dialog to setup the database/dimensions/cubes permissions

- then look at the XML: in BI Development Studio, right click on the cube item -> View Code and search for the CubePermission XML fragment to see the CubePermission, similar for DimensionPermission; in SQL Management you can right click on the cube, script Alter or Create, and then find the CubePermission XML fragment

- to be easier to read, copy the CubePermission in a separate file

- there is a 1-to-1 relationship between the AMO classes and properties and the XML, by reading the XML you will know what classes and properties to set; for example, the <CubePermission> element tells you to create in AMO a CubePermission object; the <Name> sub-element corresponds to the Name property

Adrian Dumitrascu