MySQL and Revit with Slingshot

Packages
1

Hello everyone,

I’m trying to figure out exporting things from Revit to MySQL using Slingshot.
I tried starting small and working my way up, but I seem to have hit a roadblock on step 1:

image
image1181×650 93.5 KB

I’m using Revit 2021.1.1 and the latest (albeit quite old) Slingshot package.

Is the Slingshot package finally incompatible now? Or is something else afoot?
I’ve uninstalled all other packages in an attempt to make this work (was a recommendation in a different thread with the same error).

Thanks!

2

It should work

I’d start off with some simple steps first, to verify database connectivity, such as a simple SELECT query- rather than trying to create a database from within Dynamo

For instance:

  • Create a database in workbench
  • Create a table & populate in workbench
  • Run a simple query in workbench or commandline
  • Try the same query in Dynamo
  • If that doesn’t work, try the same query in Excel

MySQL can be quite complex- particularly in permissions, server connection settings etc etc
I’d recommend just about any other relational database- say SQLite, MSSQL, or PostgreSQL

3

Hi Andrew,

I’ve:
*Created a database;
*Created a table & populated it;
*Run a simple query in HeidiSQL (which is my client of choice) - it works just fine.
*Tried the same query in Dynamo - I get the same error as above;
*Tried the same query using the ODBC node - same error as above;
*Tried the query using the SQL.SelectFrom node - same error as above;

Not sure what trying the same query in Excel would achieve.

While I understand MySQL may not be the best tool for the job, it is what I have available to me.
Any help is appreciated.

Thanks!