# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# RazorSQL Built-in Database Support

RazorSQL ships with drivers and provides extra features and functionality for the databases listed below. Click on the links below to get more detailed information about working with each database using RazorSQL.

- DB2
- Derby
- Firebird
- HSQLDB
- Informix
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SQLite
- Sybase Adaptive Server Enterprise
- Sybase SQL Anywhere

Listed below is some information about specific versions of each of these databases with regards to RazorSQL.

### DB2

Version 8.x and 9.x: The driver that ships with RazorSQL, IBM DB2 Universal Driver Type 4, allows users to connect to DB2 UDB for Linux, UNIX and Windows with no additional software required. Users that that have a valid DB2 Connect product license will be able to connect to DB2 UDB for OS/390 and z/OS, DB2 UDB for iSeries and DB2 UDB for VSE and VM servers.

Version 7.x: Connecting to DB2 7.2 may require client software to work properly, i.e. DB2 Connect. If using the DB2 Net driver, the DB2 proxy server, db2jstrt[.exe], must be enabled. The proxy defaults to port 6789. Please be sure to use the JDBC driver version that matches the DB2 version and fix pack you are using.

Earlier Versions: RazorSQL has not been tested on versions of DB2 prior to 7.x. Connections can be made to these databases, but not all RazorSQL features may work properly.

### Derby

RazorSQL ships with Derby embedded and network/server drivers, so for almost all cases, RazorSQL can connect to and communicate with Derby out of the box.

### Firebird

RazorSQL ships with the Firebird Jaybird drivers, so for almost all cases, RazorSQL can connect to and communicate with Firebird out of the box.

### HSQLDB

RazorSQL ships with the HSQLDB drivers, so for almost all cases, RazorSQL can connect to and communicate with HSQLDB out of the box. At this time, the built-in relational database engine that ships with RazorSQL uses HSQLDB.

### Informix

RazorSQL ships with the Informix JDBC driver, so for almost all cases, RazorSQL can connect to and communicate with Informix out of the box.

### MySQL

RazorSQL does not ship with JDBC drivers for MySQL because of licensing restrictions on distributing MySQL JDBC drivers. However, RazorSQL does provide an auto-install feature that will automatically download and install the MySQL driver. If manually downloading the driver, it is recommended that the latest stable version of the MySQL Connector/J driver be used to connect to MySQL databases.

If connecting to a MySQL server on a different machine, you will need to grant access to the user and host/ip address you are using to connect to MySQL. MySQL uses the HOSTS table to determine whether a connection is allowed. The following command can be used to grant a user access:

GRANT ALL PRIVILEGES ON [database_name].* to '[user]'@'[hostname]' identified by '[password]'

### Oracle

Versions 10g and 11g: The driver that ships with RazorSQL, the Oracle 10g driver, allows users to connect to Oracle 10g or 11g with no additional software required if using the Oracle Thin Driver option. If using OCI, the 10g or 11g OCI client software must be installed on the user's machine.

Version 9i: The driver that ships with RazorSQL, the Oracle 10g driver, is compatible with Oracle 9i with no additional software required if using the Oracle Thin Driver option. If using OCI, the 9i OCI client software must be installed on the user's machine, and you should use the Oracle 9i JDBC driver to connect, not the Oracle 10g driver that ships with RazorSQL.

Earlier Versions:: If using 8i or earlier, you may need to obtain the JDBC drivers specific to the Oracle version you are using. RazorSQL is no longer tested on earlier verisons of Oracle. Connections may be made to these databases, but not all RazorSQL features may work properly.

### PostgreSQL

Version 7.x and 8.x: RazorSQL ships with the PostgreSQL 8.x JDBC driver. This driver is compatible with versions 7 and 8 of PostgreSQL. Previous versions of PostgreSQL have not been tested using RazorSQL. Connections may be made to these previous versions, but not all RazorSQL features may work properly.

If connecting to PostgreSQL on a different machine, be sure to either start PostgreSQL with the -i option, which enables TCP/IP connections, or edit the pg_hba.conf file in the PostgreSQL data directory to allow connections from the machine you are using.

### SQL Server

RazorSQL ships with the jTDS JDBC driver which is compatible with SQL Server versions 2008, 2005, 2000, 7, and 6.5.

RazorSQL supports Single Sign-On for SQL Server when running RazorSQL on Windows.. Select the Windows Single Sign-On option in the connection wizard to connect to SQL Server using the login credentials of the current logged in user of the operating system.

RazorSQL supports Windows Authentication for SQL Server. To use Windows Authentication, select the Windows Authentication option in the Connection Wizard and enter the Windows domain the user belongs to, the login id, and the password.

### SQLite

RazorSQL ships with the RazorSQL SQLite Driver, which works by communicating with the SQLite command line program.

RazorSQL for Windows ships with the sqlite3 command line program, and on Mac OS X 10.4 machines, the SQLite command line program is preinstalled in the /usr/bin/sqlite3 location. For other operatings systems, the sqlite3 command line program must be present in order for the RazorSQL SQLite driver to work.

There are JDBC drivers available for SQLite. They can be used by going through the JDBC connection type option in the Add Connection Profile process.

### Sybase

RazorSQL ships with the jTDS JDBC driver, which is compatible with Sybase Adaptive Server 10, 11, 12, and 15. RazorSQL also ships with Sybase jConnect 5.5, which is compatible with Sybase Adpative Server and SQL Anywhere.