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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |