This readme documents the latest recommended client drivers, issues, and updates.
SQL Offline uses client drivers to read from and write to data files and servers.
The Installation Video shows how to install client drivers, and how to list the supported drivers that are already installed on your computer.
Note: If (32-bit) is specified for a data driver in the following table, you should download the 32-bit version of that driver.
You can install 32-bit ODBC and OLEDB drivers on a 64-bit operating system.
|Access||2010 Office System Driver: Access Database Engine (32-bit)|
|dBASE||Driver: Microsoft OLE DB Provider for Visual FoxPro 9.0|
|Excel||2010 Office System Driver: Access Database Engine (32-bit) (same as Access)|
|MySQL||MySQL Driver mysql-connector-odbc-5.2.4-win32.msi Windows (x86, 32-bit) Connector|
|Oracle||Oracle Client Driver: Oracle Database 11g Release 2 Client (18.104.22.168.9) (32-bit)|
|Postgre||Postgre Driver: psqlOBDC (32-bit). For example: psqlodbc_09_02_0100.zip|
|SQL Server||Microsoft SQL Server 2012 Native Client: sqlncli.msi. (If running on Windows 32 sqlncli.msi)|
|Windows Azure SQL Database||Microsoft SQL Server 2012 Native Client: (same as SQL Server)|
|SQL Server CE||SQL Server Compact Driver: Microsoft SQL Server Compact 4.0|
|SQLite||Driver: SQLite ODBC Driver (32-bit) sqliteodbc.exe|
SQL Offline works with prior versions of client drivers. If you provide a connection string, SQL Offline can also work with newer client drivers.
SQL Offline can connect to any ODBC or OLEDB client. However if SQL Offline is unable to identify the DBMS, the SQL language may not be correct (unknown providers default to SQL Server). As a general rule DML (Insert, Update, Delete) writes will be successful, but DDL (Create, Alter) modifications will not work. As a workaround, you can execute custom SQL.
Online updates to this readme visit http://inters.com/docs/readme.htm.
For update notices follow us on Twitter @SQLOffline http://twitter.com/SQLOffline.
SQL Offline © 2014 Interscape Corporation