all groups > sql server odbc > july 2005 >
You're in the

sql server odbc

group:

SQL server connection in a wireless atmosphere


SQL server connection in a wireless atmosphere awj
7/29/2005 5:48:01 PM
sql server odbc: We are running a dedicated program that uses SQL server in an ad hoc
invironment between multiple laptops. The OS is Windows 2K pro.
The problem we are having is that the SQL connection is being lost even
though the wireless connection is intact.
Does anyone have an idea what may be causing this?
The laptops are Panasonic Toughbooks CF73 with Centino, 256MB memory and a
Re: SQL server connection in a wireless atmosphere Mike Epprecht (SQL MVP)
7/30/2005 12:00:00 AM
Hi

Easy then, install the application on a PC that does not use wireless and
use it. If there are no errors, it means it is the wireless networking.

I know of a company that has 70% of their network wireless and run some
pretty heavy applications, without problems.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Re: SQL server connection in a wireless atmosphere awj
7/30/2005 5:37:04 AM
Is there a solution for either instance?
The dedicated programs author says it is a SQL issue, although I wouldn't
put my money on what he says either since he won't offer any help with the
SQL side of his program other than to say it is a SQL problem.
The programs name is Donor-ID by Healthcare, Inc. It is a program to track
blood donations and their donors.
Art

[quoted text, click to view]
Re: SQL server connection in a wireless atmosphere awj
7/30/2005 5:39:03 AM
Is there a solution for either instance?
The dedicated programs author says it is a SQL issue, although I wouldn't
put my money on what he says either since he won't offer any help with the
SQL side of his program other than to say it is a SQL problem.
The programs name is Donor-ID by Healthcare, Inc. It is a program to track
blood donations and their donors.
Art


[quoted text, click to view]
Re: SQL server connection in a wireless atmosphere Mike Epprecht (SQL MVP)
7/30/2005 9:16:10 AM
Hi

Does the application close the connection after each query and re-open it
when it needs it again? If not, consider it Development principle of
"acquire late, release early").

In a wireless network connections may be dropped for very short periods of
time. The problems you are seeing are network related and not SQL Server
issues.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

AddThis Social Bookmark Button