Supported databases

Many users ask us what database(s) does WinSQL work with. The answer to this question is that WinSQL works with ANY database for which a driver is available - ODBC driver in the case of WinSQL and JDBC driver in the case of JaySQL.

WinSQL as well as JaySQL strictly adheres to the open specifications of ODBC and JDBC, which is not specific to any database. All relational databases these days support these specifications and therefore all you need is an ODBC/JDBC driver to connect to the back-end database.

All database specific features are provided via Plugins, which are plain XML files.

Here is a partial list of databases that you can use with WinSQL

  • Oracle Plugin available
  • Sybase Plugin available
  • IBM DB2 Plugin available
  • MS SQL Server Plugin available
  • Informix Plugin available
  • Pervasive SQL Plugin available
  • MySQL Plugin available
  • PostgresSQL Plugin available
  • Mimer SQL Plugin available
  • Sybase SQL Anywhere Plugin available
  • Netezza Plugin available
  • Teradata Plugin available
  • Yellowbrick Plugin available
  • What are plugins?
    Plugins allow WinSQL to retrieve data from the database that is normally not possible with ODBC API. For example there is no API in ODBC to fetch scripts for Triggers, Views and Stored Procedures. This void is filled by plugins.

    IMPORTANT: If we do not provide plugin for a database it does NOT mean you cannot connect to it. If you like you can write your own plugin, which are plain text files in XML format.

  • ANTs Database
  • Centura
  • Clipper
  • DBase
  • FileMaker
  • Firebird
  • Interbase
  • MS Access
  • MS Excel
  • Daffodil DB
  • NexusDB
  • OpenIngres
  • Paradox
  • Progress
  • SQLBase
  • Teradata
  • Text files
  • ThinkSQL
  • TimesTen
  • And the list goes on...
  • Navigation

    Social Media

    Powered by