RadBuilder DataServer
Multi-tiered Applications - Overview
A multi-tiered client/server application is partitioned into logical
units, called tiers, which run in conjunction on separate machines.
Multi-tiered applications share data and communicate with one another
over a local-area network or even over the Internet. They provide many
Advantages of the Multi-tiered Database Model, such as centralized
business logic and thin client applications.
In the RadBuilder applications, sometimes called the "three-tiered
model," a multi-tiered application is partitioned into thirds:
Client application: Apps created by RadBuilder for Android provides a user interface on the user's machine (mobile device).
Application
server: RadBuilder DataServer resides in a central networking location
accessible to all clients and provides common data services.
Remote database server: Provides the relational database management system (RDBMS).
In this three-tiered model, the RadBuilder DataServer manages the flow of data between clients and the remote database server.
RadBuilder DataServer
The RadBuilder DataServer is a desktop application that works on Windows system.
You can download the RadBuilder DataServer version 2.0 here http://www.longtion.com/download/RadBuilderDataServer.zip
It is a zip file that include x86 and x64 applications. You can unzip
it to your Windows desktop computer and run the DataServer.exe file,
press the Start button to start the server or press the Settings button
to set the connections and database settings.
You can create apps, use the DBTable object to get data from remote data server or DBQuery object to execute
SQL queries on remote database server, browse the result sets on
mobile devices.
Connections settings
User Name: Specifies the name of the user for the connections.
Password: Specifies the password for a given user name, for user's connections.
Port: Specifies the DataServer port number for the user's connections.
For apps created by RadBuilder will connect to this DataServer, the
RempoteUserName, RemotePassword and RemotePort properties of the DBTable or
DBQuery object should be same as these settings and the RemoteHost
property of the DBTable or DBQuery object should be the computer IP
address.
Database settings
You can set the DBMS's connection definition parameters, such as server
name, port, database, client character set, user name, and password.
The possible set of parameters depends on the DBMS kind to connect to.
The text is a list of string items, each representing a different DBMS connection definition parameter.
The RadBuilder DataServer supports a wide range of Database Management Systems (DBMS).
Name |
DriverID |
Required libraries (Client) Win32 |
Required libraries (Client) Win64 |
Server and client version |
Advantage Database Server |
ADS |
ace32.dll |
ace64.dll |
Server and client v 8.0 and higher |
Sybase SQL Anywhere |
ASA |
ODBC driver |
ODBC driver |
Server and client v 5.0.0 and higher |
IBM DB2 Server |
DB2 |
ODBC driver |
ODBC driver |
Server and client v 8.1 and higher |
Firebird |
FB |
fbclient.dll |
fbclient.dll |
Firebird and fbclient.dll v 1.5 and higher |
InterBase Server |
IB |
gds32.dll |
ibclient64.dll |
Interbase v 6 and higher |
InterBase Lite / InterBase ToGo |
IBLite |
ibtogo.dll |
ibtogo64.dll |
Interbase v 6 and higher |
Informix |
Infx |
ODBC driver |
ODBC driver |
Server v 8 and higher. Informix Client SDK v 3.5 and higher |
Microsoft Access Database |
MSAcc |
|
|
|
Microsoft SQL Server |
MSSQL |
|
|
|
MySQL Server |
MySQL |
libmysql.dll |
libmysql.dll |
Server and client 3.21 and higher |
Oracle Server |
Ora |
Oracle Client |
Oracle Client |
Server and client 8.0.3 and higher |
PostgreSQL |
PG |
libpq.dll |
libpq.dll |
Server v 7.4 and higher |
SQLite database |
SQLite |
sqlite3.dll |
sqlite3.dll |
SQLite database version 3.0 and later |
Teradata Database |
TData |
ODBC driver |
ODBC driver |
Server and client version 13 and higher |
MongoDB Database |
Mongo |
libbson-1.0.dll
libmongoc-1.0.dll
msvcr100.dl |
libbson-1.0.dll
libmongoc-1.0.dll
msvcr100.dll |
Server and client version 3.0 and higher |
For example, MySQL database:
The RadBuilder DataServer supports the MySQL Server Community and Enterprise editions version 3.21 and later.
The RadBuilder requires one of the following x86 or x64 (for Win32 or Win64) libraries:
The LIBMYSQL.DLL client library for connecting to MySQL server. Ideally, the version should be equal to the server version.
The LIBMYSQLD.DLL embedded server library.
You can take them from a server installation Bin or Lib folders and place them in:
a folder listed in your PATH environment variable (for example,
<Windows>\SYSTEM32) or the RadBuilder DataServer EXE folder.
Samples for database settings
[MSAccess sample]
DriverID=MSAcc
Database=x:\path_to_database\db.mdb
Note: For Access database "*.accdb", it need "Microsoft Access Driver (*.mdb, *.accdb)" x86 and x64 ODBC driver version 12 or later for 95-2010 databases installed.
For more information:
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255
[SQLite sample]
DriverID=SQLite
Database=x:\path_to_database\db.sdb
[MySQL sample]
Note: Need libmysql.dll file (x86, x64) in the PATH or current directory (the DataServer EXE directory).
DriverID=MySQL
Server=mysrv
Database=addemo
User_Name=root
Password=
Connect to a locally running server, listening on the default (3306) port:
DriverID=MySQL
Database=addemo
User_Name=root
Password=
Connect to a remote server, listening on a non-default port, using Unicode for character data:
DriverID=MySQL
Server=mysrv
Port=3307
Database=addemo
CharacterSet=utf8
User_Name=me
Password=123
Connect to an embedded server, using Unicode for character data:
DriverID=MySQL
Database=addemo
CharacterSet=utf8
[Oracle sample]
DriverID=Ora
Database=ORA_920_APP
User_Name=ADDemo
Password=a
Note: Need OCI installed.
[MSSQL sample]
DriverID=MSSQL
Server=127.0.0.1
Database=Northwind
User_Name=sa
Password=a
[InterBase Sample]
DriverID=IB
Server=localhost
Database=x:\path_to_db\db.fdb
User_Name=sysdba
Password=masterkey
[Firebird Sample]
DriverID=FB
Server=localhost
Database=x:\path_to_db\db.fdb
User_Name=sysdba
Password=masterkey
[ODBC sample]
Connect to PostgreSQL:
DriverID=ODBC
User_Name=postgres
Password=marlboro
ODBCDriver=PostgreSQL ANSI
ODBCAdvanced=SERVER=localhost;PORT=5432;DATABASE=addemo
Connect to Sybase Adaptive Server Enterprise:
DriverID=ODBC
ODBCDriver=Adaptive Server Enterprise
ODBCAdvanced=server=da;port=5000;quotedidentifier=1
Database=addemo
User_Name=sa
MetaDefCatalog=addemo
MetaDefSchema=dbo
Connect to Informix Dynamic Server:
DriverID=ODBC
ODBCDriver=IBM INFORMIX ODBC DRIVER
User_Name=informix
Password=informix2
Database=sysuser
Admin Password
You can set the admin password for administration. If the admin
password is not blank, it need to input the password before you
administrate the DataServer and settings.
|