Is it possible to connect to an ultralite db from PB 12?

[kimon_moschandreou]

Hello,

It is not possible to connect through odbc and I cannot find any info in the PB documentation. I could suppose to use the .net interface through PB .net but is there any option through PB classic?

[CobyKako · Accepted solution]

Hello Kimon,

Here are my thoughts about your question:

With Sybase PocketBuilder, it was possible to connect to Ultralite databases... but this product is gone.

Ultralite databases usage is intended for mobile device applications ad not for "traditional" client/server apps, so I doubt it is possible to connect, unless to use an ODBC driver suitable for such apps.

Jacob

[chris_keating]

I would be interested in learning why you would like to use UltraLite versus SQL Anywhere in this context. SQL Anywhere is a more rich SQL database server that still has a relatively small footprint. It can be used in a standalone context but also as a client/server database server supporting thousands of users and TBs of data.

Just curous...

[kimon_moschandreou]

Thank you for the answers

[Former Member]

Hi Kimon;

1) You can connect directly to SA Ultralite using ODBC. If IP "Tunneling" is in effect, you can even connect to the UL instance on a hand held device from the PB IDE.

2) You can use Sybase's "MobiLink" product to connect to UL and then create a ML NVUO in PB 12 that brokers the connection for you and can also move data back and forth between UL and a conventional DBMS like ASE, SS, Oracle, etc.

3) You can not build a PB 12 application and deploy it to a mobile device that consumes an UL database. As Jacob correctly states ... PB's mobile "cousin" (PocketBuilder was EOLed).

4) You can use and consume a UL database on a mobile device using an application built in PB if you also have and use the new Appeon Mobile 2.0 product!   (fyi: http://www.appeon.com) 

HTH

Regards ... Chris

[chris_keating]

Some clarification to your comments.

The UltraLite "ODBC" driver design and purpose is to provide the mimimum level of ODBC support to allow the SQL Anywhere Administration tools (dbisql and Sybase Central) to connect to an UltraLite database. Its use outside of the SQL Anywhere Administration tools is not supported. Further, that file is not listed as part of the deployment files for UltraLite which indicates its use outside of a development environment is not permitted.

PocketBuilder shipped an UltraLite database driver interface. That was done as the UL ODBC was insufficient for use as an interface between PocketBuilder and UL.

You should also be aware that any data movement via MobiLink or any method requires licensing.  That includes any sort of manually movement of data if that movement changes the application from a standalone application. There was a thread in the UltraLite newsgroups when PocketBuilder was an active product clarifying that requirement.   Further, the software that ships with PowerBuilder is licensed for development only. There is a royalty free SQL Anywhere runtime edition but there are specific usage restrictions to remain royalty free i.e., data must be for standalone application use only.

Appeon does not list UltraLite as a supported database.

[Former Member]

Hi Chris;

FYI ...

1) The Appeon documentation lists 43 references to UL.

2) Yes, UL 12.0.1 is supported ... (from the help file)

Appeon for PowerBuilder 2013 R2 supports the following client/offline databases:

• UltraLite 12.0.1

  According to SAP Sybase SQL Anywhere Supported Platforms, UltraLite supports Android-ARM only, and does not support Android-X86. Which means, if your Android device is powered by Intel or AMD x86 processors, rather than RISC-based ARM chips, then your device will not have offline accessibility to the local UltraLite database.

• SQLite 3.x

3) UL access & updating is controlled by the Appeon Enterprise Manager ...

Note: SQLLite is also supported which is royalty free!

HTH

Regards ... Chris

[chris_keating]

Sorry, I was looking at the wrong FAQ which was for Appeon Mobile. Thanks for correctly that error.

[Former Member]

FYI ... Appeon 2013R2 is "Appeon Mobile 2.0".