|
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:
| Database |
Versions
1 |
Web
site |
|
| MS SQL Server |
2005, 2008 |
|
|
| Sybase SQL Anywhere |
9 |
|
|
| MySQL |
4.1.18, 5.x |
|
|
| PostgreSQL |
8.0 |
|
|
| Firebird |
1.5 |
|
|
| IBM DB2 |
9 |
|
|
1
Other versions may work; these are the versions with which we
have most recently tested ThumbsPlus and the scripts.
2
Right-click and select Save Link As
or Save Target As to save the script
to your computer. Use the 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.
Please post questions or problems with these
databases to the cerious.advanced
newsgroup.
|
