Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

Command selection

You can connect to MySQL, PostgreSQL, Oracle, and SQLite databases without having to install the corresponding database engine's client connectivity libraries.

For MySQL, you have the option to connect directly, or use the libmysqld.dll client library.

connect_direct_mysql  
 
For PostgreSQL, SQL Spreadsheets always connects directly to the server, without the need for any client libraries to be installed.

connect_direct_postgresql  

For Oracle, you can connect directly to a server without using the Oracle Call Interface (OCI) library. However, there are some limitations to using the direct mode, the details of which can be found here.

connect_direct_oracle  
 
For SQLite, you can connect directly, or use the sqlite3.dll file. If you choose to connect directly, SQL Spreadsheets uses version 3.7.13 of the SQLite engine.

connect_direct_sqlite