SQL Offline

SQL Offline Version 2.0 - 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 SQL Offline Installation Video shows how to install client drivers, and see which drivers are already installed on your computer.

Recommended Data Drivers

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)
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 (11.2.0.1.0) (32-bit)
Postgre	Postgre Driver: psqlOBDC (32). For example: psqlodbc_09_01_0200-1.zip
SQL Server	Native Client Driver: Microsoft SQL Server 2012 Native Client
Windows Azure SQL Database	Native Client Driver: 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

Older (and Newer) Data Driver Versions

SQL Offline works with prior versions of client drivers. If you provide a connection string, SQL Offline can also work with newer client drivers.

Unknown Providers (ODBC and OLEDB)

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.

Known Issues (Problems, Workarounds, and Fixes)

Online updates to this readme visit http://inters.com/docs/readme.htm.
For update notices follow us on Twitter @SQLoffline http://twitter.com/SQLOffline.

2.0.0.7 - APR 06 2012 (Public Release)

PostgreSQL: If you copy to a different table, clear the default (nextval sequence) for the ID column.
MySQL: The 5.2a (ANSI) driver does not enable the MySQL menu. To work around this problem you can enter the connection string (right-click on Providers in the Source Window):
Provider=MSDASQL.1;Extended Properties="Driver=MySQL ODBC 5.2a Driver"
You can also install mysql-connector-odbc-5.2.4-win32.msi (as opposed to mysql-connector-odbc-5.2.4-ansi-win32.msi) and replace 5.2w with 5.2a in the connection string.