Differences

This shows you the differences between two versions of the page.

--- code:data:sql [2011/01/26 19:01] – [Driver] jmgr
+++ code:data:sql [2011/04/20 20:33] (current) – removed jmgr
@@ Line 1: / Line 1: @@
-====== Sql ======
-This object allows you to establish a connection to a SQL database like MySQL, PostgreSQL, SQLite and others.
-===== Functions =====
-==== Sql ====
-Constructor function.
-=== Syntax ===
-<code javascript>
-var myObject = new Sql(driver);
-</code>
-=== Arguments ===
-  - driver - ([[#driver|Driver]]) the database driver to use
-=== Exceptions ===
-  * (NoDatabaseDriverError) no database driver specified
-=== Example ===
-Create a Sql object operating on a MySQL database.
-<code javascript>
-var myObject = new Sql(Sql.MySQL);
-</code>
-=== Notes ===
-On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.
-To see all available drivers call the [[#drivers|drivers]] function.
-===== Enumerations =====
-==== Driver ====
-SQL drivers. On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.
-=== Values ===
-  - SQLite2: [[http://www.sqlite.org/|SQLite 2]]
-  - SQLite: [[http://www.sqlite.org/|SQLite 3]]
-  - PostgreSQL: [[http://www.postgresql.org/|PostgreSQL]] (versions 7.3 and above)
-  - MySQL: [[http://www.mysql.com/|MySQL]]
-  - ODBC: [[http://msdn.microsoft.com/en-us/library/ms710252(v=vs.85).aspx|Open Database Connectivity]] (ODBC) - Microsoft SQL Server and other ODBC-compliant databases
-  - InterBase: [[http://www.borland.com/fr/products/interbase/index.html|Borland InterBase]] ([[http://www.firebirdsql.org/|Firebird]])
-  - OCI: [[http://www.oracle.com/technetwork/database/features/oci/index.html|Oracle Call Interface Driver]]
-  - TDS: [[http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise|Sybase Adaptive Server]] (obsolete)
-  - DB2: [[http://www-01.ibm.com/software/data/db2/|IBM DB2]] (version 7.1 and above)