Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Accessing Mobile SQlite db fails

  1. How-to
0
Votes
Undo
  1. Simone Olianti
    Simone Olianti
  2. PowerServer Mobile (Obsolete)
  3. Tuesday, 24 December 2019 11:59 AM UTC

Hello everyone, i'm experiencing a problem accessing a local mobile sqlite database on an android smartphone.

This happening only after enabling performance Boosters (10X Web file compression and Merge files).
If i disable those settings and re-deploy my web application everything working fine again.

I've already configured webserver to accept the transfer of the f* files

this is how i connect to the local sqlite db using sqlca transaction object:

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=sqlite_locale;UID=dba;PWD=sql',DelimitIdentifier='Yes';EnabledLocalDB='true'"    
connect using sqlca;
If SQLCA.SQLCode <> 0 Then
    MessageBox ("Errore di Connessione al Database.", SQLCA.SQLErrText, stopsign!, ok! )        
End If   

Connection looks successful, since i don't get any error, but everytime i try to access a datastore pointing to sqlca i get an error.

what cound be the cause?

 

tia and Merry Christmas everyone!

Attachments (2)
Screenshot_20191224-114159.jpg Screenshot_20191224-114159.jpg
Screenshot_20191224-114143.jpg Screenshot_20191224-114143.jpg
PowerServer (PB Edition ) license with proxy Scrip...
SAP Ultralite 17 on mobile app
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 December 2019 16:02 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # Permalink

Hi Simone;

  Yes,  please do not enable the "10X Web file compression and Merge files" options for the mobile environment when using a local Mobile DB. The above options are actually for Web Apps only.

  If you need your App to run in both web and mobile environments, I would recommend deploying a separate Web and Mobile profile for your App. Do not use the "Both" option. The you can "tweak" the App options for each environment more specifically without interference. Food for thought.

Regards ... Chris

Comment
Simone Olianti
  1. Simone Olianti
  2. Friday, 27 December 2019 10:13 AM UTC
thank you Chris, i've managed to solve it as u said. Deploying using separated profiles helped.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 27 December 2019 16:55 PM UTC
Hi Simone ... that is great news! Thanks for letting us know that this avenue worked for you.
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.