Connections

Hello everyone,
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsiz
e.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 200
0.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:

> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpools
ize.
> My question is how many connections can we make simultaneously to SQL serv
er
> 2000.
> Experts if u can give me an optimal configuration for this it will be real
ly
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...[vbcol=seagreen]
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>

Connections

Hello everyone,
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsize.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 2000.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:
> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpoolsize.
> My question is how many connections can we make simultaneously to SQL server
> 2000.
> Experts if u can give me an optimal configuration for this it will be really
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
--
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>> Hello everyone,
>> I am configuring the connection pooling for my web application.
>> We are using Sql Server 2000 as backend.
>> I need to specify initial connection poolsize and maximum
>> connectionpoolsize.
>> My question is how many connections can we make simultaneously to SQL
>> server
>> 2000.
>> Experts if u can give me an optimal configuration for this it will be
>> really
>> helpful
>> Thanks

Connection Properties on Expressions?

Hi,

I can seem to find all the necessary properties of a connection in the expression section... except for the password...

How the hell do i specify the password for a connection based on a variable?

Regards,

Have you tried building a connection string and including the password that way.

Alternatively use windows authentication, but I'm sure you've thought of that.

|||

Yes i have already tought about both of them.. but in the connection String that is built using the interface and choosing SQL Auth the password is never there.. well i will try that way but it was a little bit easier and safer if the connection could receive a Password parameter and possibly encrypt it for use... don't know!

I'll try and see about that!

Regards,

Connection Problem with Remote Server

If I do this:
select * from tblAmcareDetail
I get my records back but as soon as try to specify column names I get:
Server: Msg 207, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'apexorderid'.
I think it must be a connection problem because I don't have this problem on
local servers. The server is registered by it's ip address and I'm running
the query under the servers sa account.
Can anyone help?Doesn't sound like a connection problem.
Are you sure the table on the server.database you're connecting to has
this column?
Is the server/db/table you're connecting to perhaps setup with a
case-sensitive collation? If so, you'll need to query using the case of
column names as in the table definition.
Spike wrote:
> If I do this:
> select * from tblAmcareDetail
> I get my records back but as soon as try to specify column names I get:
> Server: Msg 207, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
> 'apexorderid'.
> I think it must be a connection problem because I don't have this problem
on
> local servers. The server is registered by it's ip address and I'm runnin
g
> the query under the servers sa account.
> Can anyone help?
>