Question regarding SQLQueryPlugin

[whatever]

Hi!
I wanted to test Jack's SQLQueryPlugin (1), but I got the following
error: "Error ActiveXObject is not defined".
I'm using XAMPP 1.7.3 for ccTiddly, which comes with a sample database
called cdcol, so in my SQLConfig tiddler, I put the following:
cds: DRIVER={SQL Server};SERVER=(localhost);DATABASE=cdcol;

My test query is:
<<SQLQuery sql:"SELECT * FROM `cds`" connection:cds>>

Any ideas?
w

(1) http://jackparke.googlepages.com/jtw.html#SQLQueryPlugin

[UBi]

Hi whatever,

Your'e trying it with MS IE?

For me, the plugin works with queries like

<<SQLQuery sql:"select testCol1 from testTable" connection:testDSN>>

No backticks around the table name.

In SQLConfig, I have:

testDSN: DRIVER={SQL
Server};SERVER=DBServer;DATABASE=testDB;UID=testUser;pwd=testPW;

[whatever]

Hi!
I mostly use Firefox, but I tried in IE, Opera, Flock and Chrome as
well.
I tried various settings:
mycds1: DRIVER={SQL
Server};SERVER=(127.0.0.1:3306);DATABASE=cdcol;UID=root;
mycds2: DRIVER={SQL Server};SERVER=(local:
3306);DATABASE=cdcol;UID=root;
mycds3: DRIVER={SQL Server};SERVER=(localhost:
3306);DATABASE=cdcol;UID=root;
mycds4: DRIVER={SQL
Server};SERVER=(127.0.0.1);DATABASE=cdcol;UID=root;
mycds5: DRIVER={SQL Server};SERVER=(local);DATABASE=cdcol;UID=root;
mycds6: DRIVER={SQL
Server};SERVER=(localhost);DATABASE=cdcol;UID=root;
mycds1a:
DRIVER={mysql};SERVER=(127.0.0.1:3306);DATABASE=cdcol;UID=root;
mycds2a: DRIVER={mysql};SERVER=(local:3306);DATABASE=cdcol;UID=root;
mycds3a: DRIVER={mysql};SERVER=(localhost:
3306);DATABASE=cdcol;UID=root;
mycds4a: DRIVER={mysql};SERVER=(127.0.0.1);DATABASE=cdcol;UID=root;
mycds5a: DRIVER={mysql};SERVER=(local);DATABASE=cdcol;UID=root;
mycds6a: DRIVER={mysql};SERVER=(localhost);DATABASE=cdcol;UID=root;

And the query is:
<<SQLQuery sql:"SELECT * FROM cds" connection:mycdsX>> where mycdsX is
one of the above connections.

Here are the results:
Opera (for all 12 connections): Error Undefined variable:
ActiveXObject
Chrome, Firefox and Flock (for all 12 connections): Error
ActiveXObject is not defined
IE:
Error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
Error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
Error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
Error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
Error [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server
does not exist or access denied.
Error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified
Error [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified

The DB settings are default from the XAMPP package, so user is root
and there is no password. For ccTiddly, the port is 3306. I know, not
a safe setting, but this is a temporary setup and is offline.

Any ideas?

w

[UBi]

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

[whatever]

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

[whatever]

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