No vendor provides perfect support for SQL92, and implementations differ in unusual ways.ThumbsPlus uses ANSI standard SQL92 statements via ODBC to access databases, so it may be possible to use other databases.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.Users have successfully also used Oracle and IBM DB2, but we don't currently provide scripts or technical support for these. The Professional and Network editions of ThumbsPlus additionally support the use of client/server databases, including MySQL, MariaDB, PostgreSQL, and Microsoft SQL Server. The latter is not recommended in multi-user network configurations, as its internal locking mechanism doesn't perform very well on a shared file. You may also create and use databases in SQLite 3 format. In the default configuration, ThumbsPlus uses a Microsoft Access JET database with the extension. Client/Server Database Support in ThumbsPlus
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |