ThumbsPlus

All forums => ThumbsPlus v7-v9 Questions => Topic started by: wingfield on 2014-08-28 17:58:55

Title: TP7 : what's required to open MYSQL db
Post by: wingfield on 2014-08-28 17:58:55
hello all,

still wrestling with my inability to open restored TP7 db to TP sp2.  let me ask this question.

what is required for TP7 to successfully open the MYSQL db.  here's what I'm aware of.  am I missing anything??

(a) a 32 bit ODBC connector.  I have 32 bit ODBC installed and can successfully connect to the database within the ODBC dialog box.
(b) sql mode = ANSI
(c) a valid MySQL TP 7 database - I used the script on the Cerious website.  only modification is to change "type" to "engine" since "type" is now deprecated in current version.  I can see my data in Workbench.
(d) table databaseinfo populated with valid data

in my case, I have each of these as shown below.  in fact, I can successfully look at the TP7 database in workbench with my data in it.  what could I be missing??

(http://images/uploaded/2014082821552253ffa54a6896a.jpg)

(http://images/uploaded/2014082821541953ffa50b9fb40.jpg)

(http://images/uploaded/2014082821580053ffa5e84a010.jpg)