Drivers

The Data Abstract Server editions come with drivers for connecting to many popular commercial and open source databases, though if the database you are using isn't supported it is very easy to write your own driver.

Driver support in .NET

Drivers in Data Abstract for .NET are based on existing ADO.NET providers that the library leverages to communicate with the individual database back-ends. This allows Data Abstract to communicate with just about any database, without requiring custom database specific code. How to interact with individual providers, for example to retrieve meta data or perform other database-specific actions, is described in an XML-based .daConfig file provided by DA.

The default version of this .daConfig file is embedded in the Data Abstract assemblies, but can be overridden by providing your own file with custom extensions or modifications at runtime. See Creating Drivers for more information on adding your own drivers.

Whether you are a .NET, Delphi or Cocoa developer, if you are using the new Relativity Server, your middle tier will be using the available .NET (and not Delphi) drivers.

Drivers in Delphi

Drivers in Data Abstract for Delphi are implemented as special classes descending from TDADriverReference. Because each driver links in code (and in some cases dependencies on third party libraries), drivers need to be specifically added to a server project, either by simply referencing the appropriate unit that defines them, or by dropping a placeholder driver component on a form (which essentially just adds said unit reference).

Drivers are also available as standalone .dad files (essentially .dlls) that can be loaded dynamically at runtime.

Available Drivers

As discussed earlier the two server editions of Data Abstract come with support for many database already. Below you will find a table listing all the Databases that are supported. Of course, data from any of these drivers can be consumed by any client, regardless of platform.

Please view the individual topics to find out more about the individual drivers in question. Also refer to the Creating Drivers topic to find out more about easily adding support for additional drivers, whether you're a third party DAC developer or merely want to leverage an unsupported database provider in your own project.

.NET & Relativity

Platforms
Microsoft SQL Server MSSQL.NET (2000 and below)
MSSQL2005.NET (2005 and above)
MSSQLCE.NET (Compact Edition)
-
Oracle ORACLE.NET
ODP10g.NET
ODP9i.NET
-
Open Source Databases SQLite.NET
NPGSQL.NET (PostgeSQL)
MySql.NET
MySqlv4.NET
FB.NET (Firebird)
-
Generic Providers ODBC.NET
OLEDB.NET

Delphi and legacy DAServer

Platforms
Included w/ Delphi ADO
BDE
DBX
IBX
-
Provided by RemObjects SQLite
-
Third Party AbsoluteDB
AnyDAC
DBISAM3
DBISAM4
DOA
ElevateDB
FIB
IBDAC
IBO
MyDAC
MySQLDAC
NexusDB
ODAC
PgDAC
PostgresDAC
SDAC
SQLitePass
TurboDB
UniDAC
ZEOS

See Also