Max connections for SQl 2000 on Win XP Pro

Hi,
I'm a teacher in VB and use SQL 2000 on a laptop with Windows XP Pro.
My class has 20 students, can they connect to the sql database on my laptop?
Thanks inadvanced.
Danny
Greetings from BelgiumYes they can. I guess the students will be running very
small test queries against the sql server on your laptop.
>--Original Message--
>Hi,
>I'm a teacher in VB and use SQL 2000 on a laptop with
Windows XP Pro.
>My class has 20 students, can they connect to the sql
database on my laptop?
>Thanks inadvanced.
>Danny
>Greetings from Belgium
>
>.
>|||Why Not?
Scenario 1: If students want to work on SQL Server .
You all must be within the same network/domain.
Install SQL Server client in their PC and then configure
the client if needed. Usually SQLServer Client identifies
the other Servers in the same domain automatically. If the
server is in different domain, then you have to configure
the client(Use Named Piped Protocol/TCPIP).
Scenario 2: Just if the students want to connect and query
the SQL Server database from VB applications, then use
ODBC connectivity in your application.
Hope this helps. If not, please reply with your questions
in detail.
-SQLVarad (MCDBA-1999, MCSE-1999)
Greetings from USA
>--Original Message--
>Hi,
>I'm a teacher in VB and use SQL 2000 on a laptop with
Windows XP Pro.
>My class has 20 students, can they connect to the sql
database on my laptop?
>Thanks inadvanced.
>Danny
>Greetings from Belgium
>
>.
>|||<anonymous@.discussions.microsoft.com> schreef in bericht
news:02f901c398c2$79845960$a101280a@.phx.gbl...
> Yes they can. I guess the students will be running very
> small test queries against the sql server on your laptop.
>
Thanks for the quick answer.
Yes, its for learning ADO
What are the max connection for SQL server on XP Pro or Win 2000 Pro?
Is there a difference must I install Windows 2000 or Windows 2003 server on
the laptop for te connections to te SQL database?
Greetings
Danny
> >--Original Message--
> >Hi,
> >
> >I'm a teacher in VB and use SQL 2000 on a laptop with
> Windows XP Pro.
> >My class has 20 students, can they connect to the sql
> database on my laptop?
> >
> >Thanks inadvanced.
> >
> >Danny
> >Greetings from Belgium
> >
> >
> >.
> >|||"SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> Why Not?
> Scenario 1: If students want to work on SQL Server .
> You all must be within the same network/domain.
> Install SQL Server client in their PC and then configure
> the client if needed. Usually SQLServer Client identifies
> the other Servers in the same domain automatically. If the
> server is in different domain, then you have to configure
> the client(Use Named Piped Protocol/TCPIP).
> Scenario 2: Just if the students want to connect and query
> the SQL Server database from VB applications, then use
> ODBC connectivity in your application.
> Hope this helps. If not, please reply with your questions
> in detail.
> -SQLVarad (MCDBA-1999, MCSE-1999)
> Greetings from USA
>
All the students must connect to the same sql database on the laptop. The
students use ADO for the connection.
But my question was, can all the students (20) connect the same time on the
sql database.
Thanks for your answer
Greetings form Belgium
Danny
> >--Original Message--
> >Hi,
> >
> >I'm a teacher in VB and use SQL 2000 on a laptop with
> Windows XP Pro.
> >My class has 20 students, can they connect to the sql
> database on my laptop?
> >
> >Thanks inadvanced.
> >
> >Danny
> >Greetings from Belgium
> >
> >
> >.
> >|||The answer is yes...they may all connect at the same time...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > Why Not?
> >
> > Scenario 1: If students want to work on SQL Server .
> >
> > You all must be within the same network/domain.
> > Install SQL Server client in their PC and then configure
> > the client if needed. Usually SQLServer Client identifies
> > the other Servers in the same domain automatically. If the
> > server is in different domain, then you have to configure
> > the client(Use Named Piped Protocol/TCPIP).
> >
> > Scenario 2: Just if the students want to connect and query
> > the SQL Server database from VB applications, then use
> > ODBC connectivity in your application.
> >
> > Hope this helps. If not, please reply with your questions
> > in detail.
> >
> > -SQLVarad (MCDBA-1999, MCSE-1999)
> > Greetings from USA
> >
> All the students must connect to the same sql database on the laptop. The
> students use ADO for the connection.
> But my question was, can all the students (20) connect the same time on
the
> sql database.
> Thanks for your answer
> Greetings form Belgium
> Danny
> > >--Original Message--
> > >Hi,
> > >
> > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > Windows XP Pro.
> > >My class has 20 students, can they connect to the sql
> > database on my laptop?
> > >
> > >Thanks inadvanced.
> > >
> > >Danny
> > >Greetings from Belgium
> > >
> > >
> > >.
> > >
>|||1. The actual number of user connections allowed also
depends on the version of SQL Server you are using and the
limits of your application(s) and hardware. SQL Server
allows a maximum of 32,767 user connections.
Because user connections is dynamic (self-configuring
option), SQL Server adjusts the maximum number of user
connections automatically as needed, up to the maximum
value allowable. For example, if only 10 users are logged
in, 10 user connection objects are allocated. In most
cases, you should not need to change the value for this
option. By default , it allows maximum users.
2. Sorry. Your questions is not clear to me. Can you
expalin in detail?
Thanks,
SQLVarad (MCDBA-1999,MCSE1999)
>--Original Message--
><anonymous@.discussions.microsoft.com> schreef in bericht
>news:02f901c398c2$79845960$a101280a@.phx.gbl...
>> Yes they can. I guess the students will be running very
>> small test queries against the sql server on your
laptop.
>Thanks for the quick answer.
>Yes, its for learning ADO
>What are the max connection for SQL server on XP Pro or
Win 2000 Pro?
>Is there a difference must I install Windows 2000 or
Windows 2003 server on
>the laptop for te connections to te SQL database?
>Greetings
>Danny
>
>> >--Original Message--
>> >Hi,
>> >
>> >I'm a teacher in VB and use SQL 2000 on a laptop with
>> Windows XP Pro.
>> >My class has 20 students, can they connect to the sql
>> database on my laptop?
>> >
>> >Thanks inadvanced.
>> >
>> >Danny
>> >Greetings from Belgium
>> >
>> >
>> >.
>> >
>
>.
>|||"Wayne Snyder" <wsnyder@.computeredservices.com> schreef in bericht
news:OgB%23MdMmDHA.2776@.tk2msftngp13.phx.gbl...
> The answer is yes...they may all connect at the same time...
>
Thanks for teh quich anwer.
Danny
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
> news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> >
> > "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> > news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > > Why Not?
> > >
> > > Scenario 1: If students want to work on SQL Server .
> > >
> > > You all must be within the same network/domain.
> > > Install SQL Server client in their PC and then configure
> > > the client if needed. Usually SQLServer Client identifies
> > > the other Servers in the same domain automatically. If the
> > > server is in different domain, then you have to configure
> > > the client(Use Named Piped Protocol/TCPIP).
> > >
> > > Scenario 2: Just if the students want to connect and query
> > > the SQL Server database from VB applications, then use
> > > ODBC connectivity in your application.
> > >
> > > Hope this helps. If not, please reply with your questions
> > > in detail.
> > >
> > > -SQLVarad (MCDBA-1999, MCSE-1999)
> > > Greetings from USA
> > >
> > All the students must connect to the same sql database on the laptop.
The
> > students use ADO for the connection.
> > But my question was, can all the students (20) connect the same time on
> the
> > sql database.
> >
> > Thanks for your answer
> > Greetings form Belgium
> > Danny
> >
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > > Windows XP Pro.
> > > >My class has 20 students, can they connect to the sql
> > > database on my laptop?
> > > >
> > > >Thanks inadvanced.
> > > >
> > > >Danny
> > > >Greetings from Belgium
> > > >
> > > >
> > > >.
> > > >
> >
> >
>|||Hi Wayne!
I thought that a non-server OS has connection limitations. I surely had then years ago when students
tried to run against my machine. However, this might be IPC sessions (redirector/workstation) and
only apply to Named Pipes, whereas TCP/IP Winsockets is fine...?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OgB%23MdMmDHA.2776@.tk2msftngp13.phx.gbl...
> The answer is yes...they may all connect at the same time...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Redder In Nood" <redderinnood@.hotmail-brolinpakjes.com> wrote in message
> news:YAzlb.98327$FX6.4638829@.phobos.telenet-ops.be...
> >
> > "SQLVarad" <SQLVarad@.hotmail.com> schreef in bericht
> > news:001601c398c3$e1c6c250$a601280a@.phx.gbl...
> > > Why Not?
> > >
> > > Scenario 1: If students want to work on SQL Server .
> > >
> > > You all must be within the same network/domain.
> > > Install SQL Server client in their PC and then configure
> > > the client if needed. Usually SQLServer Client identifies
> > > the other Servers in the same domain automatically. If the
> > > server is in different domain, then you have to configure
> > > the client(Use Named Piped Protocol/TCPIP).
> > >
> > > Scenario 2: Just if the students want to connect and query
> > > the SQL Server database from VB applications, then use
> > > ODBC connectivity in your application.
> > >
> > > Hope this helps. If not, please reply with your questions
> > > in detail.
> > >
> > > -SQLVarad (MCDBA-1999, MCSE-1999)
> > > Greetings from USA
> > >
> > All the students must connect to the same sql database on the laptop. The
> > students use ADO for the connection.
> > But my question was, can all the students (20) connect the same time on
> the
> > sql database.
> >
> > Thanks for your answer
> > Greetings form Belgium
> > Danny
> >
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I'm a teacher in VB and use SQL 2000 on a laptop with
> > > Windows XP Pro.
> > > >My class has 20 students, can they connect to the sql
> > > database on my laptop?
> > > >
> > > >Thanks inadvanced.
> > > >
> > > >Danny
> > > >Greetings from Belgium
> > > >
> > > >
> > > >.
> > > >
> >
> >
>

Matrix Report Question

A matrix report look like this:
Cash Bond Stock
account1 $100 $200 $300
account2 $10 $20 $30
How do I add a percent column in each asset class like this:
Cash($) Cash(%) Bond($) Bond(%) Stock($)
Stock(%)
account1 $200 20% $300 30% $500
50%
account2 $100 10% $600 60% $300
30%I have noticed its a pain to manually add a calculated feild in a matrix.
first select any textbox feild in the data area and select add column. it
will add a column at the end of the matrix. it is very difficult to move it
to where you want it to be without replacing what was in the textbox where
you attempted to move it to. so you can try and edit the code and cut both
the static textbox and the static header feilds and paste it to where you
want it. or create the colums as you build it. or create a new feild in your
SQL however the subtotal will not give you the correct %. it will just total
it instead
all in all the matrix is only good for... well...
"bo_dong" wrote:
> A matrix report look like this:
> Cash Bond Stock
> account1 $100 $200 $300
> account2 $10 $20 $30
> How do I add a percent column in each asset class like this:
> Cash($) Cash(%) Bond($) Bond(%) Stock($)
> Stock(%)
> account1 $200 20% $300 30% $500
> 50%
> account2 $100 10% $600 60% $300
> 30%
>

Matrix help

Hi all. Trying something that seems like it shoulb be simple.
Important Data:
StudentID (ex. 1, 2, 3)
Class (ex. Math, English)
Response (-10 to 10)
Here is what I'm trying to get
Student 1 Student 2 Average
Math -7 3 -2
English -1 9 4
Science 10 4 7
================================================== (sum) 2 16 9
So, here is where I am now. I've added two rows to the matrix,
one that is aggregated by MAX (or FIRST or whatever, since I
know I'll only get one StudenID per class), and one that is AVG.
That way, I can get a row that has AVG, and a column that has sum.
Is this possible? Thanks.Yes, you can use this expression in the matrix cell:
==IIF(InScope(<ClassGroupName>) And InScope(<StudentIDGroupName>),
Max(Fields!Response.Value), IIF(InScope(<ClassGroupName>),
Avg(Fields!Response.Value), Sum(Fields!Response.Value)))
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Will" <groups@.willwyatt.com> wrote in message
news:28d5f694.0407181851.2376aecf@.posting.google.com...
> Hi all. Trying something that seems like it shoulb be simple.
> Important Data:
> StudentID (ex. 1, 2, 3)
> Class (ex. Math, English)
> Response (-10 to 10)
> Here is what I'm trying to get
> Student 1 Student 2 Average
> Math -7 3 -2
> English -1 9 4
> Science 10 4 7
> ==================================================> (sum) 2 16 9
>
> So, here is where I am now. I've added two rows to the matrix,
> one that is aggregated by MAX (or FIRST or whatever, since I
> know I'll only get one StudenID per class), and one that is AVG.
> That way, I can get a row that has AVG, and a column that has sum.
> Is this possible? Thanks.