I have a question
We have recently developed a application in ASP that is being shipped to a
client server in Ireland. The ASP application has a database backend in
SQL2000. The clients server is likely to have between 25 and 40 users
accessing the application.
There will be no SQL development or amendments needed on the client server.
We will however need to replicate the data back to our HQ.
Will MSDE cover the Licensing requirements
Many Thanks in advance of your help
Carl Lightfoot
Hi Carl,
Unless the clients are all likely to be hitting the web app constantly and
you can live with the 2G database limit, I think it should be fine.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Carl Lightfoot" <CarlLightfoot@.discussions.microsoft.com> wrote in message
news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
> I have a question
> We have recently developed a application in ASP that is being shipped to a
> client server in Ireland. The ASP application has a database backend in
> SQL2000. The clients server is likely to have between 25 and 40 users
> accessing the application.
> There will be no SQL development or amendments needed on the client
server.
> We will however need to replicate the data back to our HQ.
> Will MSDE cover the Licensing requirements
> Many Thanks in advance of your help
> --
> Carl Lightfoot
|||Carl,
Remeber that the limit for simultaneous connections is 25.
The database starts to lag at 8.
[]'s
Bruno
>--Original Message--
>Hi Carl,
>Unless the clients are all likely to be hitting the web
app constantly and
>you can live with the 2G database limit, I think it
should be fine.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Carl Lightfoot"
<CarlLightfoot@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
being shipped to a[vbcol=seagreen]
database backend in[vbcol=seagreen]
25 and 40 users[vbcol=seagreen]
on the client[vbcol=seagreen]
>server.
HQ.
>
>.
>
|||Hi Bruno,
There is no 25 simultaneous connection limit. The only limit in this regard
relates to concurrent workloads.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bruno Avanco" <brunojfk@.hotmail.com> wrote in message
news:83a401c495c1$c2fc2df0$a501280a@.phx.gbl...[vbcol=seagreen]
> Carl,
> Remeber that the limit for simultaneous connections is 25.
> The database starts to lag at 8.
> []'s
> Bruno
> app constantly and
> should be fine.
> <CarlLightfoot@.discussions.microsoft.com> wrote in message
> being shipped to a
> database backend in
> 25 and 40 users
> on the client
> HQ.
Showing posts with label developed. Show all posts
Showing posts with label developed. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
MSDE Installation and usage on client PC. URGENT HELP!
Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.developersdex.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.developersdex.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
MSDE Installation and usage on client PC. URGENT HELP!
Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***
You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***
You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
MSDE Installation and usage on client PC. URGENT HELP!
Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
Subscribe to:
Posts (Atom)