The MBS Xojo (Real Studio) SQL Plugin

Plugins   Documentation   Download   Update plugin license   Mailing list
Order SQL Plugin license  

Access SQL Databases

MBS SQL Plugin.pdf 1.6M
MBS SQL Plugin.zip 5.5M
MBS SQL Plugin.dmg 5.7M

Price: 99 € plus VAT if required. Order  

This plugin part is not included if you buy a Complete license. You can use it independend of all the other plugins.

Our MBS Xojo SQL Plugin is an alternative database interface to Xojo (Real Studio). It can be used either with the database class (via SQLDatabaseMBS class) or with our own SQLConnectionMBS class which gives more options.

This plugin uses the SQLAPI++ Library and if you use this plugin, read also their documentation for the details on connecting to database servers.

The MBS Xojo SQL Plugin is a Xojo plugin for accessing multiple SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and ODBC, SQLite). It uses native APIs of target DBMS so applications developed with this plugin run swiftly and efficiently. The product also provides a low-level interface that allows developers to access database-specific features. By encapsulating a vendor's API, the plugin acts as middleware and delivers database portability. See details on supporting SQL database servers on different platforms:

Server Windows Mac OS X and Linux
Oracle Database Server Supported (OCI) Supported (OCI)
Microsoft SQL Server Supported (DB-Library, OLE DB) FreeTDS ODBC driver should be used
Sybase Supported (Open Client, ASE & ASA) Supported (Open Client, ASE & ASA)
DB2 Supported (DB2 CLI) Supported (DB2 CLI)
Informix Supported (Informix CLI) Supported (Informix CLI)
InterBase/Firebird Supported Supported
Centura (formerly Gupta) SQLBase Supported (CAPI) Supported (CAPI)
MySQL Supported (MySQL C API)  Supported (MySQL C API)
PostgreSQL Supported (libpq) Supported (libpq)
ODBC Supported Supported (iODBC, see www.iodbc.org)
SQLite Supported Supported

We have two interfaces in this plugin. SQLConnectionMBS is the native one and gives more flexibility. There is also SQLDatabaseMBS for easier porting of existing projects to our SQL Plugin. As SQLDatabaseMBS class is a subclass of the Database class, it may require a Xojo Database Server license to use (this depends on the exact rules Xojo, Inc. sets).

As with Xojo, the SQLConnectionMBS class works without a Database Server license. For the SQLDatabaseMBS class you need the Database Server license as it is a subclass for the database class.

Works with Mac OS X, Windows and Linux for Desktop, Console and Web.

You do not need to compile or provide your own SQLAPI library as the plugin contains SQLAPI. You may need database access libraries from the database vendors.

For your information:
The MBS Xojo SQL plugin license includes a cross-platform unlimited license of SQLAPI++ which costs 299 USD for a C/C++ developer. Of course this bundled license works only inside the plugin. If you want to develop with SQLAPI in C/C++, please order a separate license from SQLAPI.com website.

For using JDBC (Java Database Connection) for connecting to database using a java driver, please use our MBS Xojo Java Plugin With the JavaDatabaseMBS class.




Links
MBS Real Studio Chart Plugins