Author Topic: TP7 : what's required to open MYSQL db  (Read 2543 times)

0 Members and 1 Guest are viewing this topic.

wingfield

  • Full Member
  • ***
  • Posts: 59
    • View Profile
TP7 : what's required to open MYSQL db
« 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??