General Network Error

[Agnes]

My client hold its MS SQL server in hkbranch, Both china and hong kong
office can run the vb.net application very well via VPN. Now, they want to
reduce cost and move the MS SQL server to china 's data centre .
During testing period, the user cannot connect to the SQL server and alwasy
got "General Network Error", we said that the network connection may not be
stable and suggest move back the SQL server.

However, the Network Engineer of my client complain our application is not
stable and bad design, He said the internet connection in mainland china
sometimes will not be stable, He push us to amend our system, he said he saw
some program (in china) , can handle the disconnect network problem.
e.g As the program detect the connection is broken, hold the data and wait
update/insert until the connection is recovered. I totally no idea what is
he talking about ..
Does anyone know or understand it ??
Thanks a lot

[m.posseth]

Well ...

I guess he means a Smart data client architecture ( no this is not a
handheld app ) , in this case is meant with smart client architecture
a program that has its own data storage and is able to get the latest data
from a "Main" database server and can synchronize the changes when it has a
connection
if it doesn`t have a connection it will use its own storage engine with the
last known data .
this doens`t require so much hardware however requires a suitable design of
your app and a lot of coding

if you need 100% availlability : ( costly )

if i were you i would choose for a web based handling in this situation ,
( webservices , that take care of all data handling ) with a geographicly
clustered web and database server
the two database server can synchronize with Log shipping ( in sql 2005 this
should be easy , however with 2000 it is also possible )

hth

Michel Posseth [MCP]


"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:O7*************@TK2MSFTNGP15.phx.gbl...

My client hold its MS SQL server in hkbranch, Both china and hong kong
office can run the vb.net application very well via VPN. Now, they want to
reduce cost and move the MS SQL server to china 's data centre .
During testing period, the user cannot connect to the SQL server and
alwasy got "General Network Error", we said that the network connection
may not be stable and suggest move back the SQL server.

However, the Network Engineer of my client complain our application is not
stable and bad design, He said the internet connection in mainland china
sometimes will not be stable, He push us to amend our system, he said he
saw some program (in china) , can handle the disconnect network problem.
e.g As the program detect the connection is broken, hold the data and wait
update/insert until the connection is recovered. I totally no idea what is
he talking about ..
Does anyone know or understand it ??
Thanks a lot

[Agnes]

Thanks michel, if I use smart client design, Should I use asp.net to build
up the program but not vb.net ,right ?
in my vb.net application e.g Shipping order form, use need to fill in and
search many many ports code (real-time)
If I change to Web-base application , I think I need to re-write a new
system.
Can you recommend any web sist talking about smart Client ?
"m.posseth" <mi*****@nohausystems.nl> ¼¶¼g©ó¶l¥ó·s»D:%2****************@tk2msftngp13.phx .gbl...

Well ...

I guess he means a Smart data client architecture ( no this is not a
handheld app ) , in this case is meant with smart client architecture
a program that has its own data storage and is able to get the latest data
from a "Main" database server and can synchronize the changes when it has
a connection
if it doesn`t have a connection it will use its own storage engine with
the last known data .
this doens`t require so much hardware however requires a suitable design
of your app and a lot of coding

if you need 100% availlability : ( costly )

if i were you i would choose for a web based handling in this situation ,
( webservices , that take care of all data handling ) with a geographicly
clustered web and database server
the two database server can synchronize with Log shipping ( in sql 2005
this should be easy , however with 2000 it is also possible )

hth

Michel Posseth [MCP]


"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:O7*************@TK2MSFTNGP15.phx.gbl...

My client hold its MS SQL server in hkbranch, Both china and hong kong
office can run the vb.net application very well via VPN. Now, they want
to reduce cost and move the MS SQL server to china 's data centre .
During testing period, the user cannot connect to the SQL server and
alwasy got "General Network Error", we said that the network connection
may not be stable and suggest move back the SQL server.

However, the Network Engineer of my client complain our application is
not stable and bad design, He said the internet connection in mainland
china sometimes will not be stable, He push us to amend our system, he
said he saw some program (in china) , can handle the disconnect network
problem.
e.g As the program detect the connection is broken, hold the data and
wait update/insert until the connection is recovered. I totally no idea
what is he talking about ..
Does anyone know or understand it ??
Thanks a lot

[m.posseth]

Hello Agnes ,

You can make a Windows forms app behave as a smart data client , often the
term "smart client" is used for applications started over the web that check
in the background if there is a newer version availlable ( and download and
install it in the back ) however a smart client is also a application that
does data synchronization with a master server this aproach is often used
on handheld apps ( PDA`s )
and often used for inventory programs , cause you can check the stock with
your pda in your hand , after entering your order you walk to the office
connect your pda to your computer and the stock is synchronized to the
master database .

http://msdn.microsoft.com/smartclien...ng/definition/
a smart client is nothing else as a program that makes a decission ( that is
the smart part ) on his connection state local data processing or remote
data process for instance depending on the fact if the program could reach
the server or not , if you used a OOP aproach in your program design ( data
handling in seperate objects ) it might even be a simple task to implement
this desission structure as you only have to add a decission object (
write a piece of code that does the check to the server , and decide to
start a local or remote data object )
i hope this points you more in the right direction

regards
Michel Posseth [MCP]


"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:uz**************@tk2msftngp13.phx.gbl...

Thanks michel, if I use smart client design, Should I use asp.net to build
up the program but not vb.net ,right ?
in my vb.net application e.g Shipping order form, use need to fill in and
search many many ports code (real-time)
If I change to Web-base application , I think I need to re-write a new
system.
Can you recommend any web sist talking about smart Client ?
"m.posseth" <mi*****@nohausystems.nl>
¼¶¼g©ó¶l¥ó·s»D:%2****************@tk2msftngp13.phx .gbl...

Well ...

I guess he means a Smart data client architecture ( no this is not a
handheld app ) , in this case is meant with smart client architecture
a program that has its own data storage and is able to get the latest
data from a "Main" database server and can synchronize the changes when
it has a connection
if it doesn`t have a connection it will use its own storage engine with
the last known data .
this doens`t require so much hardware however requires a suitable design
of your app and a lot of coding

if you need 100% availlability : ( costly )

if i were you i would choose for a web based handling in this situation ,
( webservices , that take care of all data handling ) with a geographicly
clustered web and database server
the two database server can synchronize with Log shipping ( in sql 2005
this should be easy , however with 2000 it is also possible )

hth

Michel Posseth [MCP]


"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:O7*************@TK2MSFTNGP15.phx.gbl...

My client hold its MS SQL server in hkbranch, Both china and hong kong
office can run the vb.net application very well via VPN. Now, they want
to reduce cost and move the MS SQL server to china 's data centre .
During testing period, the user cannot connect to the SQL server and
alwasy got "General Network Error", we said that the network connection
may not be stable and suggest move back the SQL server.

However, the Network Engineer of my client complain our application is
not stable and bad design, He said the internet connection in mainland
china sometimes will not be stable, He push us to amend our system, he
said he saw some program (in china) , can handle the disconnect network
problem.
e.g As the program detect the connection is broken, hold the data and
wait update/insert until the connection is recovered. I totally no idea
what is he talking about ..
Does anyone know or understand it ??
Thanks a lot