var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem with using SQL Mobile on mobile device.
I have written an application in VB .NET to run on a PDA.
Development suite - Visual Studio 2005
Mobile device - Dell Axim X50v
Mobile OS - WM2003SE
It fails when trying to read data from the table, stating it cannot load the following DLL (sqlcese35.sys.dll), but some functions do work.
1) - CREATE DB - works
2) - INSERT query - works
3) - SELECT COUNT query - works
4) - SELECT fields using WHERE statement - fails with the above error
Now I've unistalled and installed the three cab files and this dll does not get installed.
I've tried google, searching on sqlcese35.sys.dll, but although it comes back with my error, it didn't help.
Anyone got an idea?
Can you post the full SELECT Count() and SELECT WHERE code?
Doing a quick search on Microsoft's DLL database turns up no reference to sqlcese35.sys.dll anywhere, although that DLL is included with SQLCE. That smacks of a bug to me, but all I can do is report it as such and let Microsoft grind on it for a while.
The simple solution is to use a One Click Install deployment package. That will load any needed DLL's from the Internet for your customers.
Here are the SQL parts to the app.
Originally Posted by
Create DB - works
Dim sqlEngine As New SqlCeEngine(SQLConnString)
'Create the cameras table
sqlTmp = sqlTmp & "CREATE TABLE cameras "
sqlTmp = sqlTmp & " ("
sqlTmp = sqlTmp & "lon float,"
sqlTmp = sqlTmp & "lat float,"
sqlTmp = sqlTmp & "name nvarchar(25)"
sqlTmp = sqlTmp & ")"
If SQLConn.State = ConnectionState.Closed Then
Dim SQLCmd As New SqlCeCommand(sqlTmp, SQLConn)
The select count - works.
SQLCmd.CommandText = "SELECT COUNT(*) from cameras"
MsgBox("Cameras loaded, " & SQLCmd.ExecuteScalar.ToString & " now in database")
The load datatable, where it fails.
Dim tmpsql As String = "SELECT lon, lat, name from cameras " & _
"WHERE lon > " & minLon & " AND lon < " & maxLon & " AND lat > " & minLat & " AND lat < " & maxLat
Dim SqlAdp As New SqlCeDataAdapter(tmpsql, SQLConn)
Datatable setup for info.
MyDT = New DataTable("POI")
Pat, are there any good examples on making the One Click Installation Package?
Quick update, the application has worked when using real GPS input, but failed with the same error when using GPS Gate to emulate the GPS device.
Now I'm confused.