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 On Oct 18, 9:56 am, UBi <[email protected]> wrote: > 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; -- 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.
