SQL Offline Version 2.3 - Readme

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.

Installation Video

The Installation Video shows how to install client drivers, and how to list the supported drivers that are already installed on your computer.

Recommended Data Drivers

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 ( (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

Older (and Newer) Data Driver Versions (ODBC and OLEDB)

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.

Update History (Features, Fixes, Known Issues)

Online updates to this readme visit http://inters.com/docs/readme.htm.
For update notices follow us on Twitter @SQLOffline http://twitter.com/SQLOffline. - JAN 06 2014 (2.3) - SEP 06 2013 (2.2) - JUL 06 2013 (2.1) - APR 06 2013 (Initial Public Release)

SQL Offline © 2014 Interscape Corporation