algorithmic modeling for Rhino
Slingshot! is an Open Source plug-in for connecting Grasshopper to relational databases
Slingshot! features collection of components for reading, writing, and managing relational database systems using SQL.
Website: http://wiki.theprovingground.org/slingshot
Members: 176
Latest Activity: Sep 8, 2023
Querying a Mesh
Queries are used to progressively assemble a mesh within Grasshopper using information stored in MySQL database tables on a remote computer.
Visualize the Database using a Web Browser
A Grasshopper model being generated and visualized in Google Chrome.
Store iterations from Galapagos to search through alternatives.
More videos and tutorials are available at the Slingshot! Wiki.....
Hi!I'm using an old version of Slingshot for quite while. In my definition, I access a remote PostgreSQL database via ODBC Driver. Consequently, I use the ODBC query component. Since this version (of…Continue
Tags: postgresql, connectionproblem, slingshot
Started by eugênio moreira. Last reply by naysok Sep 8, 2018.
Hi Everyone This might be an easy one for someone - I'm just a little bit new to this.Just wondering if someone could provide some guidance on how to set up Slingshot to work with SQLite?The…Continue
Started by David Schwarzman Apr 12, 2018.
Hi, I'm trying to use the Slingshot from the updated installer (64bit) to read an excel file (.xlsx). I'm also using Office 2016 64bit. But I got errors like these: System.NullReferenceException:…Continue
Started by David Chen. Last reply by Sean Carr Mar 6, 2018.
Maybe I just cant find the relevant information but how to decode this search result?how,…Continue
Started by Philipp. Last reply by book learnin Oct 26, 2017.
Comment
Dear Slingshot! Database users,
I have created a user survey in the hopes of improving the plug-in and determining new development possibilities.
Please take a moment and fill it out!
Best,
Nathan
Something that may be of help to everyone: http://www.connectionstrings.com
While I have provided a few connection components, they may not be appropriate for all cases. ConnectionStrings.com is a great resource for finding the correct means of connecting to a remote database.
-Nathan
Pedro, I looked into your issue further and I am able to replicate the error if the connection string is incorrect. Make sure you specify the database name you are connecting to.
Additionally, some SQL queries supported in MySQL are not supported in Postgres or there may be slight differences in syntax... for example "SHOW databases;" is not supported in Postgres.
-Nathan
I will take another look at the ODBC driver tonight to see if I can replicate your error. It seems to be working fine with my install of Postgres which makes me think that your DB configuration may be a little different.
Apparently all settings seem to be fine. Server is running on localhost, default port. Databases already loaded and ODBC drivers updated. The only problem is accessing them via grasshopper. I've managed to establish connection to a mysql server, but no success with postgres.
Pedro, You may to need to verify your Server IP and Port. Are you accessing the Postgres server though localhost or is this for remote access?
hello,
I'm trying to use slingshot's latest version with Postgres, and somehow when i try to connect it, it always returns the same message:
{0}
0. System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at SlingshotDB.GHODBC_QUERY.SolveInstance(IGH_DataAccess DA)
Does any1 know how to solve this problem?
Tks a lot,
Pedro.
Slingshot! Database v0.8.0.0 has been released. This is a major update with new features and workflow (and probably bugs!) Read more here.
Hi Nathan,
Thanks so much for your plugin!
Hereafter is a conversation which mentions Slingshot:
http://www.grasshopper3d.com/forum/topics/keep-last-galapagos-round...
I hope you can help :)
Many thanks,
Arthur
Welcome to
Grasshopper
Added by Parametric House 0 Comments 0 Likes
Added by Parametric House 0 Comments 0 Likes
Added by Parametric House 0 Comments 0 Likes
Added by Parametric House 0 Comments 0 Likes
© 2024 Created by Scott Davidson. Powered by
You need to be a member of Slingshot! to add comments!