Art Table

Art Table is a module allowing you to insert sortable, searchable tables, multiple types of data charts for easy data presentation from data sources such as HTML tables, SQL queries and CSV files.


Intro

The Connection String field in the Art Table 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

TypeDatabaseNotes
fbsqlFrontbase
gladiusGladius
maxdbMaxDB
msqlminiSQL
mssqlMSSQL
mssqlpoMSSQL Pro
mysqlMySQL
mysqliMySQLi
mysqltMySQLt
odbcODBC Can be used with any database with ODBC connection support
postgresPostgreSQL Provides connections to PostgreSQL databases below version 6.4
postgres64PostgreSQL64 Provides connections to PostgreSQL version 6.4 databases
postgres7PostgreSQL7 Provides connections to PostgreSQL version 7 databases
postgres8PostgreSQL8 Provides connections to Postgres databases version 8 and above
sqliteSqLite
sqlitepoSqLite
sybaseSybase
sybase_aseSybase