|
| Hello,
I have recently been having problems with an UltraLite database for one
of my Pocket PC based applications. The database has ~2,500 records
currently stored in the database. We are currently testing the system
using a number of various PDA's. One of our testers reported an error
of "Specified database is invalid". We were able to catch the
exception and debug the application but we could not determine what
would cause the database to suddenly become invalid. We started over
with a fresh database. The error we have now encountered a complete
application crash with an error screen that pops up with the message "A
native exception has occurred in TDCS.exe. Select Quit and then
restart this program, or select details for more information."
ExceptionCode: 0x80000002, ExceptionAddress: 0x013b7930
At that point, the Visual Studio IDE complete freezes and When I
replace the guilty UltraLite database with a fresh one, we are fine
(for now).
Here's the block of code where the app breaks:
strSQL = "SELECT * FROM tblUsers WHERE UserID='" &
LTrim(txtUserName.Text) & "' AND Password='" & Trim(txtPassword.Text) &
"'"
psNameCheck = Conn. PrepareStatement(str
SQL)
rsNameCheck = psNameCheck.ExecuteQuery
If rsNameCheck.RowCount = 0 Then '<---Here's where it breaks.
What could cause an UltraLite DB to become invalid/corrupted, and are
there any utilities available that can help assess what is happening?
Has anyone else had any problems similar to this?
Here's my configuration information:
ASA 9.0 (9.0.1.2027)
Visual Studio .net 2003 (vb.net)
Pocket PC 2K3/2K SE
..Net CF 1.0 SP3
Any help would be greatly appreciated!
|
|