Supported Databases


SQL Relay supports Oracle, MySQL, PostgreSQL, Sybase, IBM DB2, Firebird and SQLite databases directly, using the native client API's for those databases.

Support is provided for Microsoft SQL Server via the FreeTDS API. Reportedly, some versions of Microsoft SQL Server can also be accessed using some versions of the Sybase database API. So, depending on what version of Sybase you build SQL Relay against, you might be able to access certain versions of SQL Server. I have never tried this myself. Your milage may vary.

FreeTDS supports Sybase as well. So you can access both SQL Server and Sybase databases using FreeTDS.

Minimal support is provided for Microsoft Access databases via the MDB Tools API. Select queries are supported but DML and DDL is not.

ODBC is supported via the UnixODBC and iODBC libraries. If you can find a compatible ODBC driver for the database that you want to use then you should be able to access that database through SQL Relay. You can also use the ODBC to ODBC bridge to access databases for which there is no ODBC driver for the platform you are running SQL Relay on.

Microsoft recently (as of July 2012) released a SQL Server ODBC driver that is compatible with certain versions of UnixODBC on certain versions of Red Hat Enterprise Linux on the x86_64 platform, so that is another possible way to connect to SQL Server that is supported by SQL Relay.

Blackray databases can also be accessed because they implement the PostgreSQL client-server protocol.