Xojo Android/IOS and connection to Sql server or Mysql

General
1

Is there a way to connect directly to Microsoft Sql or Mysql data sources from xoxo for android or xojo for ios ?
(I know there are security issues but this could be interesting for local network systems or systems that go through vpn…)

2

I believe this is a solution
https://www.monkeybreadsoftware.net/class-sqldatabasembs.shtml

1 Like
3

But doesn’t SQLDatabaseMBS need a plugin (MBS has some built-in plugins, but not for MSSQL or MySQL), and does a plugin exists?

4

From link

“Supported databases: CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase.
Connect to Microsoft Access, FileMaker Server (or Pro), Microsoft Visual FoxPro and others via ODBC”

5

Yes, but you most often need a .dll, .dylib and .so from the database provider for Windows, macOS and Linux respectively for the connection to work.

6

You may need to get the dylib for MySQL or freetds to use on iOS.

7

Ah ok, in this case i think that the mbs plugin is not full solution (ios + android platforms )
Am i wrong ?

8

We have no Android plugins yet.
And iOS with SQL Plugin is possible, but it wants to load the native library, so you need to build it for iOS.

But really, you may prefer to have the iOS app talk to a web service and the web service talks to the database.

1 Like