Solved

Lost connectivity with database from PocketPC

Posted on 2011-03-22
4
620 Views
Last Modified: 2013-12-27
Hi,

We have an SmartDevice application, build in VB.net 2005 to manage inventory in a huge warehouse. The software connect to a SQL Server 2000 database upon entering any program's functionnality. But after a few minutes of idle, the database connection drop by itself, even if the PocketPC does not fall in sleep mode. So the operator have to get out of the current menu and re-enter it (the database connection is re-established in the form's Load method).

Any idea why the database connection drop like that? How can I fix this?

thanks for your time and help
0
Comment
Question by:Dominic34
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:kdwood
ID: 35192118
Dominic,

Can you provide the following details:

1.  What type of Smart Devices are you using?
2.  Are your Smart Devices wireless?
3.  Are you connecting to an SQL 2000 server?  If so, what method are you using to connect?

Regards,

Keith
0
 

Author Comment

by:Dominic34
ID: 35192272
1. Those are Teklogix Workabout Pro G3 and Symbol MC9090 running Windows Mobile 5.0
2. Yes, wireless
3. yes, SQL 2000. using SQLClient.SQLConnection method:

oCnn = New SqlClient.SqlConnection
            With oCnn
                .ConnectionString = "Server=" & ServerName & ";Database=" & DBName & ";" & _
                                    "User ID=" & UserName & ";Password=" & Password & ";" & _
                                    "Trusted_Connection =" & Trusted
                .Open()
            End With
0
 
LVL 10

Accepted Solution

by:
kdwood earned 500 total points
ID: 35198478
Dominic,

A few questions and things to consider:

1.  Double check to make sure that hibernate/powersave modes are turned off and/or not affecting the wireless interface.
2.  Is this a new implementation or has this system been in place for a while and just the problem is now showing up?
3.  Is it possible that your wireless access points or routers are configured to drop idle connections?
4.  From a design standpoint, we open and close database connections as needed in our code.  We abandoned trying to keep connections open, especially on wireless devices where coverage varies and signal interference can occur.  Some will argue that there is a performance hit to this approach, however, we did not see any visible performance loss and our applications are in fact more reliable.

Hope this helps,

Keith
0
 

Author Comment

by:Dominic34
ID: 35200501
1. Hibernate isn't enabled Nor is sleep mode.
2. It's an old application that run very well on other warehouses. This particular warehouse is new, PocketPC are new also
3. AP are configured exactly like the AP's at the other warehouses
4. That's a thing I was considering also, to modify the application to reconnect each time at the database on every StoredProc calls... would be a bit time consuming to do, but would fix the problem I guess...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Preface: This article is part of a series focused on cross platform mobile app development (specifically Android and iOS) using the Alloy framework and Titanium Studio made by Appcelerator (https://www.appcelerator.com/). This article presumes a wor…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now