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 ***