1. Marcos Bolonha
  2. PowerServer Mobile (Obsolete)
  3. Saturday, 4 January 2020 14:13 PM UTC

Hi,

Since we have problems using SQLite on mobile app (bug 3787) and the Appeon doesn't know when the issue will be fixed (and the project deadline is comming soon) we would like to try SAP Ultralite on that project, but I'm not able to access the database because there is no ODBC driver for Ultralite 17 available (in fact the ODBC driver installed by SQL Anywhere 17 is limited to SQLAnywhere Ultralite administration tools only). Is there any tutorial or example how to use Ultralite in mobile app?

 

PB2019 Universal Edition build 2082

PowerServer PB Edition 2151

Ultralite 17.0.4.2053

 

Regards.

Marcos

Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Sunday, 5 January 2020 01:19 AM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 1

Hi Marcos,

Please try develop with ASA database and convert it to UltraLite. You can use script like below to connect Utralite in PB application, but there is no way to connect Utralite in PB database painter.

//Connect Local Utralite Database
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='UID=dba;PWD=sql;driver={ultralite 17};dbf=D:\PS2019\B3787\mytest.udb';EnabledLocaldb='true';"


For how to use UltraLite on Mobile app, please refer to article below.
https://docs.appeon.com/appeon_online_help/ps2019/appeon_mobile_offline_tutorials/index.html


Note that SAP SQL Anywhere provides no 64-bit UltraLite database for Android OS. To work around this limitation, you can set up the 32-bit Appeon Workspace and the 32-bit UltraLite database on the 64-bit Android OS.


Regards,
ZhaoKai

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.