hello all,
well - as luck would have it, my computer crashed in a recent thunder storm. I've been busily reloading all my software for the past few days. I've now gotten around to the difficult stuff. I consider TP7 difficult. before the crash, I had successfully created a MySQL db for TP7 and was using TP7 Pro sp2; having been reluctant to move to either TP8 or TP9 based on forum comments.
well, up to this point, I've not been able to successfully get TP7 to work again with MySQL. I hope to get some assistance on this forum. Here's what I've done so far. I've gone from memory as well as making use of a very old post from the Cerious Archives by Chris Williams. I've gone ahead and posted this in it's entirety at the bottom of my post for other folks reference -as I've found it quite helpful in reconstructing TP7 with MySQL.
I'm running Win7 Home Premium 64 bit sp1 with 8gig memory
so, here's what I've done so far.
(a) installed MySQL Community Server v5.6.2 (not sure if relevant; but before my crash, I was using an older version)
(b) installed Workbench v6.1 (not sure if relevant; but before my crash, I was using an older version)
(c) ensured MySQL service is running
(d) restored my backup dump files for my ThumbsPlus db in Workbench (yep, I had a backup). I can connect to the Thumbs db in Workbench and I can see the tables in Workbench as well. My data looks fine.
(e) installed 32 bit ODBC. yep, somehow I managed to remember that TP7 is 32 bit and since I'm running Win7 64 bit, I had to install ODBC 32 bit for TP7 to see the ODBC data source.
(f) created the ThumbsPlus ODBC data source in the 32 bit ODBC.
(g) ensured that I have appropriate permissions to the schema within Workbench.
(h) changed the SQL_mode to 'ANSI' in the my.ini file.
(i) verified in Workbench that SQL_mode is set to 'ANSI'. It is.
(j) run TP7. choose "file / database / connect / machine data source/ thumbs
(k) get the following error message :<)
does anyone have any thoughts on what the problem is here?? I'd sure love to be able to get back to where I was before my laptop crashed.
thank you in advance for any help provided.
because of the 5000 character post limitation, I need to put the 5/21/2007 post from Chris Williams in a 2nd post. sorry about that.