473,385 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

General Network Error

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
Nov 23 '05 #1
3 2207
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

Nov 23 '05 #2
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


Nov 23 '05 #3
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



Nov 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: stanley j Mroczek | last post by:
Every thing is on one machine, Programs and sql. Sql is up and running(can test with query analyzer). No changes where made! This was working fine. How do you track this error? What network...
2
by: SteveS | last post by:
Hello all. This problem is stumping me.... I run a page called "default.aspx". For some reason when I execute this page, I get the error below. It seems to run through the entire code behind...
7
by: stan | last post by:
I have .net 2003 and SQL 2000 setup on one system. All I have is one computer (no network). I am able to get to the internet that works. I can run SQL Query Analyzer and it works. The program was...
0
by: David Sworder | last post by:
Hi there, I am using the SQL managed provider in ADO.NET to fill a dataset with a large number of records. I periodically get an exception with the description "General Network Error" when trying...
11
by: galina betz | last post by:
Please help! Getting this error intermittently: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not...
7
by: Joe Ross | last post by:
I've been working with Microsoft support for over 3 weeks now on an intermittent General Network Error we're seeing in our production environment between our ASP.NET application and SQL Server...
3
by: Yong | last post by:
I get a general network error when I try to make asynchronously call ExecuteNonQuery on long sql statements that run in parallel. Here is the background info on what I'm trying to accomplish: I...
0
by: Yong | last post by:
I'm not getting any reply to my previous thread so I'm stating a new one. I get a General Network Error due to my SqlCommand object not having a big enough CommandTimeout to complete very long...
0
by: johnkamal | last post by:
Hi, Some times while opening a page, I am getting the following error message, Please help me to rectify the problem. Server Error in '/' Application. General network error. Check your...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.