Art Table Lite

Create sortable, searchable, paginated tables from an SQL Query. To load data from sources other than SQL Query please see Art Table Full Version


The Connection String field in the Art Table Lite module administrator is used to supply the database type, host name, database name, username and password to the database which you are connecting to your Art Table.

Connection String Formatting

The Connection string is a comma delimited string of text formatted like this: databaseType,hostName,databaseName,userName,passWord

Connection String Examples

For MySQL: mysqli,localhost,my_database,my_username,my_password
For PostgreSQL: postgres8,localhost,my_database,my_username,my_password
For MSSQL: mssql,localhost,my_database,my_username,my_password

Supported Database Types

Type Database Notes
fbsql Frontbase
gladius Gladius
maxdb MaxDB
msql miniSQL
mssql MSSQL
mssqlpo MSSQL Pro
mysql MySQL
mysqli MySQLi
mysqlt MySQLt
odbc ODBC Can be used with any database with ODBC connection support
postgres PostgreSQL Provides connections to PostgreSQL databases below version 6.4
postgres64 PostgreSQL64 Provides connections to PostgreSQL version 6.4 databases
postgres7 PostgreSQL7 Provides connections to PostgreSQL version 7 databases
postgres8 PostgreSQL8 Provides connections to Postgres databases version 8 and above
sqlite SqLite
sqlitepo SqLite
sybase Sybase
sybase_ase Sybase