SQLite Connection Help

RazorSQL provides a custom SQLite driver that can communicate with SQLite via the SQLite command line program. RazorSQL for Windows ships with the SQLite command line program, and SQLite is included on Mac OS X Tiger and Leopard in the /usr/bin directory. For Linux systems, to use the RazorSQL SQLite driver, the SQLite command line program must first be installed. See www.sqlite.org to obtain SQLite for Linux.

Connecting to SQLite with the RazorSQL SQLite Driver

To connect to SQLite using the RazorSQL SQLite driver, open the connection wizard and select SQLite as the database type and RazorSQL SQLite Driver as the connection type. For Windows and Mac OS X machines, the path to the SQLite command line program should be automatically populated. For Linux machines, use the browse button to navigate to the SQLite command line program.

Next, choose whether to connect to an existing database file, or to have RazorSQL create a new SQLite database file. Enter the name of the existing or new file in the Database File field.

Connecting to SQLite via JDBC

RazorSQL can also connect to SQLite via JDBC. To do this, an SQLite JDBC driver needs to be downloaded. To connect, in the connection wizard, select SQLite as the database type and JDBC as the connection type. See the documentation for the JDBC driver for the Driver Class and JDBC URL.