Connecting to other SQL databases

[whatever]

Hi!
As I already posted on the TiddlyWiki group (1), I'm interested in
finding a way to connect my wiki with an SQL or mySQL database. I
tried Jack's SQLQueryPlugin (2), but I couldn't get it to work. Yet. I
only tried it in a TiddlyWiki so far. Are there any other solutions?
w

(1) http://groups.google.com/group/tiddlywiki/browse_thread/thread/9144ef17ce7e1033
(2) http://jackparke.googlepages.com/jtw.html

[Kashgarinn]

I made a plugin to query an SQL server for updates when mouseovering a
tiddler, not sure if it's what you're looking for, but it's here and
you can maybe edit it to your needs: http://sthor.tiddlyspot.com/#AjaxPluginForCCTW

S.

On Nov 3, 12:21 pm, whatever <kbrezov...@gmail.com> wrote:
> Hi!
> As I already posted on the TiddlyWiki group (1), I'm interested in
> finding a way to connect my wiki with an SQL or mySQL database. I
> tried Jack's SQLQueryPlugin (2), but I couldn't get it to work. Yet. I
> only tried it in a TiddlyWiki so far. Are there any other solutions?
> w
>

> (1)http://groups.google.com/group/tiddlywiki/browse_thread/thread/9144ef...
> (2)http://jackparke.googlepages.com/jtw.html

[whatever]

Hi!
After some testing, I got the SQLQueryPlugin 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, 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