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:

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.

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:

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.

Readerware SQL Server Configuration

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:

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.

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


Copyright © 1999-2022 Readerware Corporation