Hi!
After some testing, I got it to work, so I thought I'd share.
It seems that the plugin only works in 64-bit version of IE8 and not
in 32-bit.
The settings:
SQLConfig: mycds: DRIVER={MySQL ODBC 3.51
Driver};SERVER=127.0.0.1;DATABASE=cdcol;UID=root;PWD=;
SQLExamples: <<SQLQuery sql:"SELECT * FROM cds" connection:mycds>>It also tried: <<SQLQuery sql:"SELECT * FROM cdcol.cds WHERE (titel LIKE '%Beauty%' OR interpret LIKE '%Beauty%' OR jahr LIKE '%Beauty%' OR id LIKE '%Beauty%')" connection:mycds>> and it worked as well, but only in 64-bit IE8. The server is Apache from XAMPP 1.7.3 package, which I use for ccTiddly. The user was root and there was no pass (both default settings). Using localhost instead of 127.0.0.1 also worked, but using local as in the plugin example didn't. Also, as UBi mentioned, Firefox, Chrome and Opera are out, because the plugin uses ActiveX control. I didn't test, but I imagine Flock and Safari are also out. I tested on 64-bit Windows 7. w On Nov 3, 12:42 pm, whatever <[email protected]> wrote: > Hi! > I don't mind it working only with IE. Also, I've tried adding the > empty pwd and writing the hostname and IP address without parentheses. > I also installed the correct mysql driver (MySQL ODBC 3.51 Driver), > but I still get errors. Anyone got it to work? > > w > > On Oct 18, 9:19 pm, UBi <[email protected]> wrote: > > > The plugin uses AxtiveX, so it will definitely only work with MS IE. > > > A few guesses: Maybe you need to add an empty "pwd=;" to your > > SQLConfig entries? Or write the hostname or the IP address without > > surrounding parentheses? > > > You could try to create a working setup with the Windows ODBC > > Administration Tool and copy the DSN to your SQLConfig tiddler. > > > Good luck > > UBi -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.
