As installed, ThumbsPlus creates a database called Thumbs.tpdb8 using the Microsoft Access JET format. However, ThumbsPlus uses ODBC to communicate with its database, so other database formats can be used instead. (Note: Pro, Home Network and Network licenses only; a Standard license can only use the default JET database.)

Client/server databases offer greatly improved performance when sharing a database in a network environment, and the capability to have databases larger than the JET 2 gigabyte limit.

Upgrading from version 7: Use the menu selection Database - Advanced - Convert client/server to convert the database from the prior format.

Creating a new database: The following table has SQL scripts that you can download to create a new database of the desired format.

Note that you should open the script in a text editor to modify it for your specific database and to select the desired thumbnail size and other constants. You may want to use the tools provided with the database to create it and control the locations and names of the database data and log files. Also you may want to change the INSERTs to the ThumbsPlusDatabase table to match the desired thumbnail size, compression, and other attribute.

Other databases may be supported in the future. If you have a specific request, please submit a problem report.

¹ Other versions may work; these are the versions with which we have most recently tested ThumbsPlus and the scripts.

² Right-click and select Save Link As or Save Target As to save the script to your computer. Use notebad to make changes, then command-line or query tool for your database to execute it.

Some databases may require that you download a separate package for ODBC support, and you will need to configure an ODBC data source for connecting to the database. The ThumbsPlus version 7 Manual has information on creating an ODBC data source, in the SQL Server Administration section.

As installed, ThumbsPlus creates a database called Thumbs.td4 using the Microsoft Access JET format. However, ThumbsPlus uses ODBC to communicate with its database, so other database formats can be used instead. (Note: Pro, Home Network and Network licenses only; a Standard license can only use the default JET database.)

Client/server databases offer improved performance, especially in a network environment, and the capability to have databases larger than the JET 2 gigabyte limit.

The following databases have been tested by Cerious Software with ThumbsPlus version 7 SP2 (build 2251), and we have database creation scripts that you can customize and use to create an empty ThumbsPlus database for each of them:

¹ Other versions may work; these are the versions with which we have most recently tested ThumbsPlus and the scripts.

² Right-click and select Save Link As or Save Target As to save the script to your computer. Use notebad to make changes, then command-line or query tool for your database to execute it.

Some databases may require that you download a separate package for ODBC support, and you will need to configure an ODBC data source for connecting to the database. The ThumbsPlus version 7 Manual has information on creating an ODBC data source, in the SQL Server Administration section.