If so, I will uninstall my good old TP7 and delete the corresponding MySQL database.مجموعه نرم افزار پرنیان 2017 – ویرایش هجدهم Some hours later I can tell you now, the performance seems to be even better than MySQL with InnoDB engine.Īll 120.000 pictures are scanned and I will begin to test and check if all runs well. Now I could connect TP9 with my new PostgreSQL database. Then click the button "Datasource" an go to "". When selecting the ODBC-driver choose "PostgreSQL Unicode" (NOT ANSI!).įill in all connection data (server name, name of database, user and password). Otherwise you cannot configure 32bit ODBC drivers!
Thumbsplus 10 sp2 driver#
Next I downloaded and installed PostgreSQL ODBC driver psqlodbc_09_03_0400.zipĪgain - you have to use C:\windows\SysWOW64\odbcad32.exe on a Win7 64bit system.
I had to change the owner of all tables to thumbsplus-user. Therefore PostgreSQL did not allow access when I tried to connect with TP9. So the owner of these tables was not the thumbsplus-user. Important!: I have lost a lot of time because by mistake I created the tables as admin-user. I used this SQL-script for creation of the tables and all necessary entries in the table "ThumbsPlusDatabase" Finally TP9 now also runs with PostgreSQL 9.2 on my NAS box.Ĭreated a database with ENCODING=UTF8, collation and character type set to en_US.UTF-8Ĭhanged "idFileType" to "idFiletype" in table "Thumbnail" (I have not tested, but I think it is notĪnymore necessary with ThumbsPlus 9 SP2 I did not change the table name "ThumbsPlusDatabase" to "thumbsplusdatabase"). Queries are a lot faster with "InnoDB" engine! Therefore I converted the tables to "InnoDB":īut I was not happy, because I was not able to run TP9 with my PostgreSQL server :-(Īgain and again I have read the forum thread of KurtA, heinzelrumpel and Daan van Rooijen (thank you a lot!).
TP9 now could connect and I scanned all 120.000 pictures without troubles.Īfter some queries which where very slow I remembered, that the default engine for MySQL tables is "MyISAM". Then I used the SQL-File to create all tables and the necessary entries in table "ThumbsPlusDatabase".
I created an empty database with default settings (UTF8 character set): You have to use C:\windows\SysWOW64\odbcad32.exe. If you have Win7 64bit, you cannot use the default ODBC configuration tool. In the field "Initial Statement:" of the MySQL Connector/ODBC Data Source Configuration. SET SESSION sql_mode='ANSI_QUOTES,STRICT_TRANS_TABLES' Version 5.1 works fine with TP9 - version 5.2 does NOT! You need the 32bit ODBC driver version! The 64bit ODBC driver does not work with ThumbsPlus. As I have another application running a lot faster with PostgreSQL than with MySQL, I wanted to run all with PostgreSQL.īut after several unsuccessful days with PostgreSQL I switched to MySQL.īy the way: The database conversion TP7 -> TP9 did not work.Ī lot of time I lost because of using the most recent MySQL ODBC-driver version 5.2 that I used without any problems for my TP7-database.
Since 2007 I am using TP7 with a MySQL database. Quote Experiences with MySQL and PostgreSQL Client/Server Databaseīy pie.photo, Saturday, May 09, 2015, 16:59