Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Posts
    50

    Question Unanswered: Problem with using SQL Mobile on mobile device.

    All,

    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.

    sqlce.ppc.wce4.armv4.CAB
    sqlce.dev.ENU.ppc.wce4.armv4.CAB
    sqlce.repl.ppc.wce4.armv4.CAB

    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?

    Cheer,

    Paul.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you post the full SELECT Count() and SELECT WHERE code?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

    -PatP

  4. #4
    Join Date
    Jul 2007
    Posts
    50
    Quote Originally Posted by georgev
    Can you post the full SELECT Count() and SELECT WHERE code?
    Here are the SQL parts to the app.

    Create DB - works

    Dim sqlEngine As New SqlCeEngine(SQLConnString)
    sqlEngine.CreateDatabase()

    '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
    SQLConn.Open()
    End If

    'SQLConn.Open()
    Dim SQLCmd As New SqlCeCommand(sqlTmp, SQLConn)
    SQLCmd.ExecuteNonQuery()
    'SQLConn.Close()

    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)
    SqlAdp.Fill(MyDT)


    Datatable setup for info.

    MyDT = New DataTable("POI")
    MyDT.Columns.Add("Lon", GetType(Double))
    MyDT.Columns.Add("Lat", GetType(Double))
    MyDT.Columns.Add("Name", GetType(String))

    Pat, are there any good examples on making the One Click Installation Package?

  5. #5
    Join Date
    Jul 2007
    Posts
    50
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •