"Fossies" - the Fresh Open Source Software Archive

Member "sqlrelay-1.5.2/doc/features/databases.wt" (23 Apr 2019, 2751 Bytes) of package /linux/privat/sqlrelay-1.5.2.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 <script language="Javascript" src="../js/rotate.js"></script>
    2 
    3 = Supported Databases =
    4 
    5 <div class="slide">
    6 
    7 {{{#!td
    8 [[Image(../images/oracle.png,nolink)]]
    9 [[Image(../images/sybase.png,margin-left=10px,nolink)]]
   10 [[Image(../images/ibm.png,margin-left=10px,nolink)]]
   11 }}}
   12 {{{#!td
   13 [[Image(../images/mssqlserver.png,margin-left=10px,nolink)]]
   14 }}}
   15 
   16 </div>
   17 
   18 <div class="slide hidden">
   19 [[Image(../images/mysql.png,nolink)]]
   20 [[Image(../images/postgresql.png,margin-left=10px,nolink)]]
   21 [[Image(../images/firebird.png,margin-left=10px,nolink)]]
   22 [[Image(../images/sqlite.png,margin-left=10px,nolink)]]
   23 </div>
   24 
   25 <div class="slide hidden">
   26 
   27 {{{#!td
   28 [[Image(../images/unixodbc.png,nolink)]]
   29 [[Image(../images/iodbc.png,margin-left=10px,nolink)]]
   30 }}}
   31 {{{#!td
   32 [[Image(../images/freetds.png,margin-left=10px,nolink)]]
   33 [[br]][[br]]
   34 [[Image(../images/mdbtools.png,margin-left=10px,nolink)]]
   35 }}}
   36 
   37 </div>
   38 
   39 SQL Relay supports [http://oracle.com Oracle], [http://www.mysql.com MySQL]/[http://mariadb.com MariaDB], [http://postgresql.org PostgreSQL], [http://scn.sap.com/community/developer-center/oltp-db SAP/Sybase], [http://www-01.ibm.com/software/data/db2/ IBM DB2], [http://www-01.ibm.com/software/data/informix/ Informix], [http://www.firebirdsql.org Firebird] and [http://sqlite.org SQLite] databases directly, using the native client API's for those databases.
   40 
   41 Support is provided for Microsoft SQL Server via the [http://www.freetds.org FreeTDS] API.  Reportedly, some versions of Microsoft SQL Server can also be accessed using some versions of the SAP/Sybase database API.  So, depending on what version of SAP/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.
   42 
   43 !FreeTDS supports SAP/Sybase as well.  So you can access both SQL Server and SAP/Sybase databases using !FreeTDS.
   44 
   45 Minimal support is provided for Microsoft Access databases via the [http://mdbtools.sourceforge.net MDB Tools] API.  Select queries are supported but DML and DDL is not.
   46 
   47 ODBC is supported via the [http://www.unixodbc.org UnixODBC] and [http://www.iodbc.org 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.
   48 
   49 Microsoft released a SQL Server ODBC driver in 2012 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.
   50 
   51 <script language="Javascript">
   52 rotate();
   53 </script>