Hi all,
i am trying to connect Dynamo to an MySQL Database running on XAMPP (local) in order to import data into Revit,
The problem I’m having, is that I can’t seem to manage to connect to the database because Dynamo keeps telling me “Dereferencing a non-pointer”.
Anyone got an idea what is wrong here? I can’t seem to find my flaw
The code block at the bottom of your graph doesn’t define a table (the requested input), but attempts to call a function of a class which isn’t defined.
Just missing quotation marks…
“DB_NAME.TABLE_NAME”
Alright, thanks guys. Managed to connect to the database. but get stuck right after. Sorry, total Dynamo noob here.
Any advice on how to solve this? Not sure how to change boolean and string values in Dynamo!?
Provide a password for the connection string node.
User ‘root’ doesnt use a password (this is a local server running under XAMPP)
i also tried adding a user “hexa” using the pw “hexa” but that doesnt make a difference
//EDIT
sorry, it does make a difference, see attached:
i think the password for SQL should be something like Servername/Password or alike.
@Andrew_Hannell
so that user has access to that database ?
Have you tried replacing localhost with 127.0.0.1 or entering an obscenely high number for timeout?
Any particular reason you are using MYSQL ?
It is sophisticated- but the permissions/authentication can be complicated
You might have installed it so that it requires SHA256 authentication ie needs a TLS connection or RSA key pair. You also need to set permissions on the database (schema)- refer below screenshot
Fine if you are running a bank, possibly overkill for BIM/Dynamo use
I’d recommend:
for simplicity: SQLite - just a file you connect to, no server
for ease of use: PostgresSQL
for spatial stuff: PostgresSQL with spatial extensions: PostGIS
for recalcitrant IT depts who don’t like opensource, and drivers etc built into Windows: MSSQL Express
Please PM me if you need further help- I am a freelancer and this is how I make a living
Andrew
I forgot to say, you can also try creating an ODBC connection to touubleshoot it, & use the same details in Dynamo
Hello Hexageo,
I am currently working on something similar. I have a mysql database running on XAMPP. I linked it to mysql workbench and I want to export the max value found in the table to a userdefined parameter in REVIT.
I have no knowledge of Dynamo and would really appreciate some help please.
thanks
