MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.
Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

Multi-select parameter in SQL Server Rptg Svcs 2005

I am using a beta version of reporting services 2005.
I have created my report parameters as multi-select. However, I'm having
trouble having the query parameters accept the list that the report
parameters passes. (below) I tried replacing the = with in and between and
neither work. It doesn't like the comma between the multiple values. I
can't imagine that they've allowed multi-select report parameters without a
way to pass them cleanly to the query parameters.
Any help would be greatly appreciated. Thank you in advance for any help.
Machelle
Select * from candidate_info
where (recruiting_year in @.p_Year) and
(candidate_type_display in @.p_candidate_type) and
(degree_level in @.p_degree) and
(owner_site_code in @.p_site_owner) and
(offer_job_grade in @.p_grade)Try putting parenthese around the parameter like you normally would if you
were providing a hardcoded list ie
Select * from candidate_info
> where (recruiting_year in (@.p_Year)) and
> (candidate_type_display in (@.p_candidate_type)) and
> (degree_level in (@.p_degree)) and
> (owner_site_code in (@.p_site_owner)) and
> (offer_job_grade in (@.p_grade))
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:3EF55E31-2626-4B24-86FD-97E087999FF8@.microsoft.com...
>I am using a beta version of reporting services 2005.
> I have created my report parameters as multi-select. However, I'm having
> trouble having the query parameters accept the list that the report
> parameters passes. (below) I tried replacing the = with in and between and
> neither work. It doesn't like the comma between the multiple values. I
> can't imagine that they've allowed multi-select report parameters without
> a
> way to pass them cleanly to the query parameters.
> Any help would be greatly appreciated. Thank you in advance for any help.
> Machelle
> Select * from candidate_info
> where (recruiting_year in @.p_Year) and
> (candidate_type_display in @.p_candidate_type) and
> (degree_level in @.p_degree) and
> (owner_site_code in @.p_site_owner) and
> (offer_job_grade in @.p_grade)
>|||I love it when it's a simple answer - thanks Wayne I really appreciate your
taking the time to answer my question.
"Wayne Snyder" wrote:
> Try putting parenthese around the parameter like you normally would if you
> were providing a hardcoded list ie
> Select * from candidate_info
> > where (recruiting_year in (@.p_Year)) and
> > (candidate_type_display in (@.p_candidate_type)) and
> > (degree_level in (@.p_degree)) and
> > (owner_site_code in (@.p_site_owner)) and
> > (offer_job_grade in (@.p_grade))
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Machelle" <Machelle@.discussions.microsoft.com> wrote in message
> news:3EF55E31-2626-4B24-86FD-97E087999FF8@.microsoft.com...
> >I am using a beta version of reporting services 2005.
> >
> > I have created my report parameters as multi-select. However, I'm having
> > trouble having the query parameters accept the list that the report
> > parameters passes. (below) I tried replacing the = with in and between and
> > neither work. It doesn't like the comma between the multiple values. I
> > can't imagine that they've allowed multi-select report parameters without
> > a
> > way to pass them cleanly to the query parameters.
> >
> > Any help would be greatly appreciated. Thank you in advance for any help.
> >
> > Machelle
> >
> > Select * from candidate_info
> > where (recruiting_year in @.p_Year) and
> > (candidate_type_display in @.p_candidate_type) and
> > (degree_level in @.p_degree) and
> > (owner_site_code in @.p_site_owner) and
> > (offer_job_grade in @.p_grade)
> >
>
>

Multiple Threads and Licensing

Hello,
I am working on a project that will require the use of SQL Server 2005
Workgroup Edition. We were planning to use the version that comes with
5 CALs instead of the version that is licensed based on processors due
to the enormous cost difference.
The application I am working on is using c#. This program will spawn
multiple threads to communicate with instruments attached on the network
Each of these threads will have a connection to the db to save data. I
am being told that each thread will require a CAL. Is that correct? I
can not find anything in the licensing information that explicitly
states this. It was my understanding that a CAL is based on user or
device and could make as many connections to the db as needed.
ThanksIf you have only 5 instruments then you should be OK. Each instrument is a
user and can spawn multiple connections although I don't understand why it
would need to.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:uvdvuKjlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I am working on a project that will require the use of SQL Server 2005
> Workgroup Edition. We were planning to use the version that comes with 5
> CALs instead of the version that is licensed based on processors due to
> the enormous cost difference.
> The application I am working on is using c#. This program will spawn
> multiple threads to communicate with instruments attached on the network
> Each of these threads will have a connection to the db to save data. I am
> being told that each thread will require a CAL. Is that correct? I can
> not find anything in the licensing information that explicitly states
> this. It was my understanding that a CAL is based on user or device and
> could make as many connections to the db as needed.
> Thanks|||If you have only 5 instruments then you should be OK. Each instrument is a
user and can spawn multiple connections although I don't understand why it
would need to.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:uvdvuKjlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I am working on a project that will require the use of SQL Server 2005
> Workgroup Edition. We were planning to use the version that comes with 5
> CALs instead of the version that is licensed based on processors due to
> the enormous cost difference.
> The application I am working on is using c#. This program will spawn
> multiple threads to communicate with instruments attached on the network
> Each of these threads will have a connection to the db to save data. I am
> being told that each thread will require a CAL. Is that correct? I can
> not find anything in the licensing information that explicitly states
> this. It was my understanding that a CAL is based on user or device and
> could make as many connections to the db as needed.
> Thanks|||Hi Roger,
Thanks for replying.
I want to make sure I understand how this works. My program will be
running on the same computer as the SQL server. It will collect data
from up to 32 instruments in 32 threads. Based on this data, I will
save information to the database, 1 record for each instrument. Is this
considered multiplexing or pooling and that is why I would need 32 CALs?
If I used just 1 connection would 1 CAL be sufficient?
I will also have a couple of other computers that connect to this main
computer and view and edit the data. I know these will require separate
CALs.
I called MS Volume Licensing and was told that for each connection to
the database I needed a CAL period. If I have 1 user that opens up 5
connections (example 5 different programs) to the database that would
use 5 CALs. If I took 1 program that made a connection to the db and
ran it twice on the same computer that would require 2 CALS. Any
program I write needs a CAL for each connection to the database. To me
this seems like the CALs are based on connections and not users or
devices. Is that correct?
So I guess my real question is: Is a user or device CAL is only good
for 1 connection to the database? If the program this user is running
for whatever reason makes 2 connections to the database it requires 2
CALs even though its coming from the same user or device?
I have searched MS's website and have not found any solid information on
how this licensing is really suppose to work.
Thanks again
Roger Wolter[MSFT] wrote:
> If you have only 5 instruments then you should be OK. Each instrument is
a
> user and can spawn multiple connections although I don't understand why it
> would need to.
>|||Hi Roger,
Thanks for replying.
I want to make sure I understand how this works. My program will be
running on the same computer as the SQL server. It will collect data
from up to 32 instruments in 32 threads. Based on this data, I will
save information to the database, 1 record for each instrument. Is this
considered multiplexing or pooling and that is why I would need 32 CALs?
If I used just 1 connection would 1 CAL be sufficient?
I will also have a couple of other computers that connect to this main
computer and view and edit the data. I know these will require separate
CALs.
I called MS Volume Licensing and was told that for each connection to
the database I needed a CAL period. If I have 1 user that opens up 5
connections (example 5 different programs) to the database that would
use 5 CALs. If I took 1 program that made a connection to the db and
ran it twice on the same computer that would require 2 CALS. Any
program I write needs a CAL for each connection to the database. To me
this seems like the CALs are based on connections and not users or
devices. Is that correct?
So I guess my real question is: Is a user or device CAL is only good
for 1 connection to the database? If the program this user is running
for whatever reason makes 2 connections to the database it requires 2
CALs even though its coming from the same user or device?
I have searched MS's website and have not found any solid information on
how this licensing is really suppose to work.
Thanks again
Roger Wolter[MSFT] wrote:
> If you have only 5 instruments then you should be OK. Each instrument is
a
> user and can spawn multiple connections although I don't understand why it
> would need to.
>|||First, (disclaimer) I'm not a licensing expert.
As I understand your problem, you have one client program (where it executes
is immaterial -standalone or server).
That one client application has multiple threads connecting to various
input/output devices -including keyboard, mouse, etc.
That one client application obtains information from those input/output
devices, and then that one client saves data in SQL Server.
I believe you have one client requiring one CAL.
The various input/output devices are not connecting to SQL Server.
Consider other various input/output devices. Should you have a separate CAL
for keyboard, mouse, PLC, barcode reader, digital tablet, etc. I think you
can see where I'm going. If your various 'instruments' directly connected to
SQL Server, (and had the intelligence to use that connection) they would
require CALs -but they do not. You application is not serving as a 'proxy'
for these input/output devices (as a web server serves as proxy to
individual client sessions.)
If I have 10 (or whatever number) of client applications running on a single
computer, each running in its own thread, each connected to SQL Server, I
only need a single CAL (either device or user). Except of course, if by
using terminal services, or Citrix, my computer is serving as a proxy for
other computers -then each proxied connection requires its own CAL.
Let me know if this helps,
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:uvdvuKjlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I am working on a project that will require the use of SQL Server 2005
> Workgroup Edition. We were planning to use the version that comes with 5
> CALs instead of the version that is licensed based on processors due to
> the enormous cost difference.
> The application I am working on is using c#. This program will spawn
> multiple threads to communicate with instruments attached on the network
> Each of these threads will have a connection to the db to save data. I am
> being told that each thread will require a CAL. Is that correct? I can
> not find anything in the licensing information that explicitly states
> this. It was my understanding that a CAL is based on user or device and
> could make as many connections to the db as needed.
> Thanks|||My interpretation is that you would need 32 CALs to cover your 32 devices
but I'm not a lawyer so you need to go with what the licensing people say.
To me, your situation is the same as 32 users connecting to a middle tier
application that opens up one or more connections to the database. In that
case you pay for 32 CALs because what counts is users of the database not
connections. Conversely, those same 32 users could each open 2 connections
to the database and still only require 32 CALs. I don't know if there's a
different policy if your users are really inanimate objects (I've had users
that were pretty inanimate but that's a different story) so you need to talk
to the licensing people.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:%231sopWtlGHA.4076@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Hi Roger,
> Thanks for replying.
> I want to make sure I understand how this works. My program will be
> running on the same computer as the SQL server. It will collect data from
> up to 32 instruments in 32 threads. Based on this data, I will save
> information to the database, 1 record for each instrument. Is this
> considered multiplexing or pooling and that is why I would need 32 CALs?
> If I used just 1 connection would 1 CAL be sufficient?
> I will also have a couple of other computers that connect to this main
> computer and view and edit the data. I know these will require separate
> CALs.
> I called MS Volume Licensing and was told that for each connection to the
> database I needed a CAL period. If I have 1 user that opens up 5
> connections (example 5 different programs) to the database that would use
> 5 CALs. If I took 1 program that made a connection to the db and ran it
> twice on the same computer that would require 2 CALS. Any program I write
> needs a CAL for each connection to the database. To me this seems like
> the CALs are based on connections and not users or devices. Is that
> correct?
> So I guess my real question is: Is a user or device CAL is only good for
> 1 connection to the database? If the program this user is running for
> whatever reason makes 2 connections to the database it requires 2 CALs
> even though its coming from the same user or device?
> I have searched MS's website and have not found any solid information on
> how this licensing is really suppose to work.
> Thanks again
> Roger Wolter[MSFT] wrote:|||As I said before, I'm not a licensing expert. I have engaged in lengthly
conversations with legal staff at several major manufacturing 'partners'
about my concerns in regards to licensing. I'm relating to what I have been
told and observed to be in actual practice.
There are a number of products in the process control field that serve to
collect input from PLC devices in manfacturing, and then store that input in
database servers such as SQL Server. Those products collect the data,
perhaps 'massage' it in some way, and then save the data in a data server.
Logically, it's really not much different than using a keyboard as an input
device -and often with as little 'intelligence' as a keyboard.
According to your logic, every major manufacturer is out of complicance
since they are not buying a CAL for each and every production line input
device. (Of course, Microsoft would like that, but the very large
manfacturing user base would be extremely uncomfortable with that analysis.)
I think the key is "Can (or) Does the device directly use the connection
with or without the 'middleman' application? If so, as in the case of any
middle tier (COM server, Web server, etc.) application, a CAL is required.
It seems that if the device could never use a connection with/or without the
'middleman' application, it 'may' not require a CAL. (Note the
equivocation -I'm not a licensing specialist. And sometimes when chatting
with VL phone folks, it takes a bit of explaining (sometimes over and over)
to be clearly understood -after all, their job is to sell licenses -not help
the customer avoid unneeded licenses!)
Perhaps Patrict needed assistance in understanding how to more clearly
communicate the issues to the VL folks. If so, I hope I helped. If I muddied
the waters, I offer my regrets.
However, as always, since everything changes so fast and so much, I am open
to my continued education...(And I'm backing out of this conversation
leaving it to more learned hands.)
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OhoxvVxlGHA.4100@.TK2MSFTNGP05.phx.gbl...
> My interpretation is that you would need 32 CALs to cover your 32 devices
> but I'm not a lawyer so you need to go with what the licensing people say.
> To me, your situation is the same as 32 users connecting to a middle tier
> application that opens up one or more connections to the database. In
> that case you pay for 32 CALs because what counts is users of the database
> not connections. Conversely, those same 32 users could each open 2
> connections to the database and still only require 32 CALs. I don't know
> if there's a different policy if your users are really inanimate objects
> (I've had users that were pretty inanimate but that's a different story)
> so you need to talk to the licensing people.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
> news:%231sopWtlGHA.4076@.TK2MSFTNGP03.phx.gbl...
>|||First, (disclaimer) I'm not a licensing expert.
As I understand your problem, you have one client program (where it executes
is immaterial -standalone or server).
That one client application has multiple threads connecting to various
input/output devices -including keyboard, mouse, etc.
That one client application obtains information from those input/output
devices, and then that one client saves data in SQL Server.
I believe you have one client requiring one CAL.
The various input/output devices are not connecting to SQL Server.
Consider other various input/output devices. Should you have a separate CAL
for keyboard, mouse, PLC, barcode reader, digital tablet, etc. I think you
can see where I'm going. If your various 'instruments' directly connected to
SQL Server, (and had the intelligence to use that connection) they would
require CALs -but they do not. You application is not serving as a 'proxy'
for these input/output devices (as a web server serves as proxy to
individual client sessions.)
If I have 10 (or whatever number) of client applications running on a single
computer, each running in its own thread, each connected to SQL Server, I
only need a single CAL (either device or user). Except of course, if by
using terminal services, or Citrix, my computer is serving as a proxy for
other computers -then each proxied connection requires its own CAL.
Let me know if this helps,
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:uvdvuKjlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I am working on a project that will require the use of SQL Server 2005
> Workgroup Edition. We were planning to use the version that comes with 5
> CALs instead of the version that is licensed based on processors due to
> the enormous cost difference.
> The application I am working on is using c#. This program will spawn
> multiple threads to communicate with instruments attached on the network
> Each of these threads will have a connection to the db to save data. I am
> being told that each thread will require a CAL. Is that correct? I can
> not find anything in the licensing information that explicitly states
> this. It was my understanding that a CAL is based on user or device and
> could make as many connections to the db as needed.
> Thanks|||My interpretation is that you would need 32 CALs to cover your 32 devices
but I'm not a lawyer so you need to go with what the licensing people say.
To me, your situation is the same as 32 users connecting to a middle tier
application that opens up one or more connections to the database. In that
case you pay for 32 CALs because what counts is users of the database not
connections. Conversely, those same 32 users could each open 2 connections
to the database and still only require 32 CALs. I don't know if there's a
different policy if your users are really inanimate objects (I've had users
that were pretty inanimate but that's a different story) so you need to talk
to the licensing people.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Patrick Brand" <"pbrand$NOSPAM$"@.ludlums.com> wrote in message
news:%231sopWtlGHA.4076@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Hi Roger,
> Thanks for replying.
> I want to make sure I understand how this works. My program will be
> running on the same computer as the SQL server. It will collect data from
> up to 32 instruments in 32 threads. Based on this data, I will save
> information to the database, 1 record for each instrument. Is this
> considered multiplexing or pooling and that is why I would need 32 CALs?
> If I used just 1 connection would 1 CAL be sufficient?
> I will also have a couple of other computers that connect to this main
> computer and view and edit the data. I know these will require separate
> CALs.
> I called MS Volume Licensing and was told that for each connection to the
> database I needed a CAL period. If I have 1 user that opens up 5
> connections (example 5 different programs) to the database that would use
> 5 CALs. If I took 1 program that made a connection to the db and ran it
> twice on the same computer that would require 2 CALS. Any program I write
> needs a CAL for each connection to the database. To me this seems like
> the CALs are based on connections and not users or devices. Is that
> correct?
> So I guess my real question is: Is a user or device CAL is only good for
> 1 connection to the database? If the program this user is running for
> whatever reason makes 2 connections to the database it requires 2 CALs
> even though its coming from the same user or device?
> I have searched MS's website and have not found any solid information on
> how this licensing is really suppose to work.
> Thanks again
> Roger Wolter[MSFT] wrote:

Multiple SQL Version

Dear all,
Can I install several version of MSDE in my PC ?
Thanks.You should be able to install multiple instance of MSDE on the same machine.
When you install a new MSDE instance just make sure that it has a different
instance name than already existing ones, else you will encounter an
instance clash error. All common files will be replaced if it detects that
it the one you are installing has a newer version, else it will be left
alone.
--
HTH
Ryan
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
> Dear all,
> Can I install several version of MSDE in my PC ?
> Thanks.
>|||So I can have SQL Server 7 and SQL Server 2000 desktop at the same machine ?
May I know the URL to download those versions ?
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eoTT7nEEGHA.2872@.TK2MSFTNGP14.phx.gbl...
> You should be able to install multiple instance of MSDE on the same
machine.
> When you install a new MSDE instance just make sure that it has a
different
> instance name than already existing ones, else you will encounter an
> instance clash error. All common files will be replaced if it detects
that
> it the one you are installing has a newer version, else it will be left
> alone.
> --
> HTH
> Ryan
> "Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
> news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
> > Dear all,
> >
> > Can I install several version of MSDE in my PC ?
> > Thanks.
> >
> >
>

Multiple SQL Version

Dear all,
Can I install several version of MSDE in my PC ?
Thanks.You should be able to install multiple instance of MSDE on the same machine.
When you install a new MSDE instance just make sure that it has a different
instance name than already existing ones, else you will encounter an
instance clash error. All common files will be replaced if it detects that
it the one you are installing has a newer version, else it will be left
alone.
HTH
Ryan
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
> Dear all,
> Can I install several version of MSDE in my PC ?
> Thanks.
>|||So I can have SQL Server 7 and SQL Server 2000 desktop at the same machine ?
May I know the URL to download those versions ?
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eoTT7nEEGHA.2872@.TK2MSFTNGP14.phx.gbl...
> You should be able to install multiple instance of MSDE on the same
machine.
> When you install a new MSDE instance just make sure that it has a
different
> instance name than already existing ones, else you will encounter an
> instance clash error. All common files will be replaced if it detects
that
> it the one you are installing has a newer version, else it will be left
> alone.
> --
> HTH
> Ryan
> "Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
> news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
>

Multiple SQL Version

Dear all,
Can I install several version of MSDE in my PC ?
Thanks.
You should be able to install multiple instance of MSDE on the same machine.
When you install a new MSDE instance just make sure that it has a different
instance name than already existing ones, else you will encounter an
instance clash error. All common files will be replaced if it detects that
it the one you are installing has a newer version, else it will be left
alone.
HTH
Ryan
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
> Dear all,
> Can I install several version of MSDE in my PC ?
> Thanks.
>
|||So I can have SQL Server 7 and SQL Server 2000 desktop at the same machine ?
May I know the URL to download those versions ?
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eoTT7nEEGHA.2872@.TK2MSFTNGP14.phx.gbl...
> You should be able to install multiple instance of MSDE on the same
machine.
> When you install a new MSDE instance just make sure that it has a
different
> instance name than already existing ones, else you will encounter an
> instance clash error. All common files will be replaced if it detects
that
> it the one you are installing has a newer version, else it will be left
> alone.
> --
> HTH
> Ryan
> "Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
> news:#MwUmNBEGHA.2956@.TK2MSFTNGP14.phx.gbl...
>

Multiple SQL Server Native Client Versions

One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version.

My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam.

Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory with a particular version of the Oracle client dlls (along with corresponding registry entries for that Oracle Home), such that we control the exact client version of the Oracle software that the client uses with our applications. This will not interfere with, and is completely seperate, from the default Oracle home installed when you install the Oracle client software.

What I would like to see for the Native Client is the ability to have our applications use the version of the Native Client that we wish to support and deploy without interfering with the Native Client version used by other applications. Have a default Native Client, but allow applications to somehow specify a different Native Client version/set of DLLs.

Is there any such functionality with the Native Client? (I didn't see any mention of such in the documentation, but I thought I'd ask)

If not, are there any future plans to support multiple Native Client versions on the same desktop?

At present, there is only one version of the SQL Server Native Client, so the particular issue you've raised isn't technically a concern at this point (which may explain why you didn't find any obvious discussion of the topic).

In the SQL Server Native Client blog, Chris and/or Acey discuss the history of issues that were encountered with multiple versions of MDAC and specifically discuss the issue you've brought up above (the blog posting is at: http://blogs.msdn.com/sqlnativeclient/archive/2006/09/27/774286.aspx ). They go on to specifically mention:

By wrapping the OLE DB and ODBC technologies into a single library, we are able to avoid these issues by making a clean break from MDAC so that you can effectively deploy SQL Native Client as needed, without concern about if it will “play nicely” with other versions of MDAC.

So, for you app today, you can build against the SQL Server Native Client and deploy that application (including the SQL Server Native Client redistributable) to your clients without breaking existing MDAC based applications.

As to the future, making this clean break only to commit to the same course of action with the new SQL Server Native Client would be less than ideal and we are actively considering how best to support this need in the next release that will come with future versions of Microsoft SQL Server. If you have specific scenarios or issues you would like considered, we would very much like to hear your ideas.

Multiple select in 2005 Beta 2

I have heard that the ability to do multi-selects (selecting multiple records
in a drop down prompt) would be possible in the 2005 version of ssas. I have
the Beta 2 version and still do not think it is possible. Any help would be
greatly appreciated.Multi-value parameters are not supported in Beta 2.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:10D5F583-946B-4A2D-8079-8F711114B2C2@.microsoft.com...
>I have heard that the ability to do multi-selects (selecting multiple
>records
> in a drop down prompt) would be possible in the 2005 version of ssas. I
> have
> the Beta 2 version and still do not think it is possible. Any help would
> be
> greatly appreciated.|||Is this something that is PLANNED for the general release?
"Rajeev Karunakaran [MSFT]" wrote:
> Multi-value parameters are not supported in Beta 2.
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:10D5F583-946B-4A2D-8079-8F711114B2C2@.microsoft.com...
> >I have heard that the ability to do multi-selects (selecting multiple
> >records
> > in a drop down prompt) would be possible in the 2005 version of ssas. I
> > have
> > the Beta 2 version and still do not think it is possible. Any help would
> > be
> > greatly appreciated.
>
>