imec
I am also experiencing this issue.
< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
VS 2003
Windows Mobile 2003 running Compact Framework 1, service pack 3 (also tried Compact Framework 2)
My application is a simple form with a timer control that polls a SQL Server 2000 database every 15 seconds. I use a class level SqlClient.SqlConnection object to execute a stored procedure via a configured SqlCommand object.
I run the application in debug mode and it successfully polls the database several (anything up to 70) times. It uses the same connection object each time who's connection is simply opened and closed for each poll.
After the error has occurred, the project will not run on the device again until the device is soft reset. It is almost the behaviour of a memory leak of some kind although I am not creating objects that are accumulating. Additionally, the error is clearly caught in the try, catch block as sqlException "SQL Server does not exist or access denied". Very strange indeed after so many successful executions of the stored procedure.
I have tried everything I can think of including:
Deploying the app to the device and running it directly over the LAN, bypassing ActiveSync.
Experimenting with different timeout values on the connection and command objects.
Any help would be very much appreciated.