Erik Salaj from Winsoft has released a JDBC library for Delphi XE5 Firemonkey which allows you to access Microsoft SQL Server from Android. The library is I believe a wrapper of the JTDS project which is an open source java driver for MSSQL. It provides it’s own interface for the library which you receive the source for once you purchase the library. The library also supports two other databases which are H2 and Sybase SQL databases. I have not seen another solution for accessing Microsoft SQL Server on Android with Delphi XE5 Firemonkey (Devart’s SDAC only works on Windows) at this time. There is a free trial of this library so you can try it out and see if it fits your needs. Additionally, you can buy it with the Winsoft Component Package which is a huge suite of components for Android, IOS, and Windows at a really good price.
FMXExpress.com has over 700 tips and tricks for building cross platform apps on Android, IOS, OSX, Windows, and Linux with a single codebase and single UI using the FireMonkey framework found in Delphi and C++Builder.
FMXExpress covers top cross platform secrets for FireMonkey in C++Builder and Delphi XE5, XE6, XE7, XE8, Seattle, Berlin, Tokyo, Rio, and Sydney.
Is tested with mssql 2008 or mssql 2012 express ?
If test ok, i will buy…
Yes, it was tested with MS SQL 2012. Free trial version with demo example is
available at http://www.winsoft.sk/ajdbc.htm, so you can download and check
how can we use image field on mssql ? only string field
1. use VARBINARY(MAX) field type in MS SQL database
2. use this code to read VARBINARY field:
// read bytes
Data := ResultSet.getBytes(FielIndex);
// show length
// show bytes
for i := 0 to Data.Length – 1 do