Personal Edition

I am going to be purchasing SQL 2000 Standard Edition, in order to use the personal edition software, because we only have windows 98 and me. What my questions is, that we I have the personal edition running on one of my two machines. Will I be able to
connect to the database from another machine. We use a manufactoring program and it will be running a SQL database, when I connect to my program is it going to give me an error about not being able to connect to the personal edition? Thanks
Rocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp
[vbcol=seagreen]
Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks
|||All that I will be doing with it is installing the SQL Server on a machine, and connecting to the database through a program that we use.
-- Dinesh T.K wrote: --
Rocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp
[vbcol=seagreen]
Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks
|||Rocky,
So, as per your plan, your database would be running SQL2000 personal
edition and the application connects to this database.Coming back to the
concurrent query limit, does many users use this application concurrently?
Personal edition as well as MSDE can support only upto 8 concurrent queries
before things get real slow and messy.
I must admit, even at this point, Iam not sure if this application is used
for dev purposes or production.Can you please answer that?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:2A41E566-1039-48F4-8F2C-AF53CD8A6382@.microsoft.com...
> All that I will be doing with it is installing the SQL Server on a
machine, and connecting to the database through a program that we use.
>
> -- Dinesh T.K wrote: --
> Rocky,
> Is this solely for development purposes? Then go for SQL2000 dev
edition.It[vbcol=seagreen]
> comes cheap too!Refer the below url for pricing details:
> 'Developer Edition Licensing'
> http://www.microsoft.com/sql/howtobuy/development.asp
> Yes.Please note that personal edition has a documented limitation of
> handling concurrent queries.
not
> being able to connect to the personal edition?
> Well, since I have not seen the connection code, I cant say for
sure.But ,
> provided the connection code is correct, there is no reason why it
wont[vbcol=seagreen]
> connect to the SQLServer just because its a personal edition.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "rocky" <anonymous@.discussions.microsoft.com> wrote in message
> news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
use the
> personal edition software, because we only have windows 98 and me.
What my
> questions is, that we I have the personal edition running on one of
my two
> machines. Will I be able to connect to the database from another
machine.
> We use a manufactoring program and it will be running a SQL database,
when I
> connect to my program is it going to give me an error about not being
able
> to connect to the personal edition? Thanks
>
>
|||First of all thanks for all your help. There will only be two at most concurrently connected. That is if you count the server as one. As far as your question I guess I am confused and I am sorry for that. Whether or not it is development or not. I th
ink it is just production. Because all we are doing is using a program that connects to the database, and updates the database as necessary, so whether or not that is developement or production I am not sure. From reading off of Microsoft's site it wasn
't clear if I could connect more than one machines to a personal edition server, but from your answer I guess I can. So thanks for you help.