Using External Databases

Most users will use the built-in database. However advanced users can use other database engines to store their data.

Readerware supports MySQL, SQL Server, and PostreSQL, however it should be possible to use any database that includes a JDBC driver. Contact Readerware support for assistance on getting other databases to work with Readerware.

To access an external database from within Readerware you need to use the advanced open dialog. This is activated in Preferences.

Connecting to an external database or a Readerware server requires Readerware Client/Server Edition. If the Advanced Open Dialog option is disabled, you don't have Readerware Client/Server Edition. Upgrades are available on the website.

Using Readerware with MySQL

You need to install MySQL and create an empty database. Refer to the MySQL documentation for assistance with installation.

You will also need the MySQL JDBC driver, Connector/J. This is available from the MySQL web site, unfortunately licensing restrictions prevent us from including Connector/J with Readerware.

Opening a MySQL Database

Select the File->Open Database menu item and the Advanced Open Dialog will be displayed.

From the Database type drop down list, choose MySQL.

Readerware MySQL Database Connection

The dialog will be filled with appropriate values. There are a couple of entries you will need to customize:

Enter your MySQL user name and password.
In the URL field, change {hostname} to the machine name or IP address where MySQL is running. Use Localhost if it is running on the same machine.
In the URL field, change {database name} to the name of the MySQL database, you must have already created the empty database in MySQL.
In Driver Location click on Browse and select the MySQL Connector/J driver

Using Readerware with Microsoft SQL Server

You need to install SQL Server and create an empty database. Refer to the SQL Server documentation for assistance with installation.

You will also need the Microsoft SQL Server JDBC driver installed.

Opening a SQL Server Database

Select the File->Open Database menu item and the Advanced Open Dialog will be displayed.

From the Database type drop down list, choose SQL Server.

Readerware SQL Server Database Connection

The dialog will be filled with appropriate values. There are a couple of entries you will need to customize:

Enter your SQL Server user name and password.
In the URL field, change {hostname} to the machine name or IP address where SQL Server is running. Use Localhost if it is running on the same machine.
In the URL field, change {instance name} to the name of the SQL Server instance you are connecting to.
In the URL field, change {database name} to the name of the SQL Server database, you must have already created the empty database in SQL Server.
In Driver Location click on Browse and select the Microsoft SQL Server JDBC driver

Click on the Test Connection button and Readerware will attempt to connect to the database. If successful click on the OK button to open the database. If the database is empty Readerware will create the necessary tables.

If you get a connection error check to make sure that SQL Server has been set up to accept TCP/IP connections. Use the SQL Server Configuration Manager and select Network Configuration. Now select Protocols for the SQL Server instance you are connecting to. Make sure TCP/IP support is enabled as shown in the screen below.

Readerware SQL Server Configuration

You also need to set the correct TCP/IP port for IPAll. Right click on TCP/IP and select Properties from the popup menu. Select the IP Addresses tab. Locate IPAll and set it to use port 1433 or whatever port you are using.

Using Readerware with PostgreSQL

You need to install PostgreSQL and create an empty database. Refer to the PostgreSQL documentation for assistance with installation.

You will also need the PostgreSQL JDBC driver. This is available from the PostgreSQL web site, unfortunately licensing restrictions prevent us from including it with Readerware.

Opening a PostgreSQL Database

Select the File->Open Database menu item and the Advanced Open Dialog will be displayed.

From the Database type drop down list, choose PostgreSQL.

Readerware PostgreSQL Database Connection

The dialog will be filled with appropriate values. There are a couple of entries you will need to customize:

Enter your PostgreSQL user name and password.
In the URL field, change {hostname} to the machine name or IP address where PostgreSQL is running. Use Localhost if it is running on the same machine.
In the URL field, change {database name} to the name of the PostgreSQL database, you must have already created the empty database in PostgreSQL.
In Driver Location click on Browse and select the PostgreSQL driver

Changing Databases

If you want to change database engines and move an existing database to a new format, use backup and restore.

Backup your existing database and then run the restore selecting the backup file you just created. On the Database Selection page of the wizard, click on the Browse button and select the new database as normal.

For example you could backup a standard Readerware database and restore it to a MySQL database. Once the restore completes Readerware will open your new database and your existing data will be displayed.

Important note: You must restore the backup to an empty database. Do not open the external database in Readerware first as that will create the standard database tables and the restore will fail. Create an empty database and then restore a Readerware backup to it.

Top of Page