I am trying to edit a database setup in Microsoft SQL Sever Manager and have noticed that the Slingshot package seems to only have 4 command nodes. Has anyone been successful in using Slingshot with Microsofts SQL software?
Yes, it works fine
You just use a code block to build the ‘command’, rather than nodes such as SQL.InsertInto- for example if you wanted an UPDATE query
MSSQL can be a little tricky with things like authentication, named instances (servers) vs default instances, security or connection settings, firewall etc etc- but it does work. For this reason, I’d recommend SQLite if you are starting from scratch- it is very simple & easy.
Search on this forum for posts by myself or others for SQL
I have recently been working with exporting bulk information from rvt files to a database, I’ve tried using the slingshots nodes with no luck, so it took me a while but I worked it out by using .Net Api SqlClient and I’m able to do any operation from dyamo to a MSSQL DB.
import clr
clr.AddReference(‘System.Data’)
from System.Data import SqlClient
from System.Data import *
from System.Data import DataTable
import clr
clr.AddReference(‘System’)
from System import *
from System import Console
from System import Data
from System.Collections.Generic import *
sqlConnectionString = “server=servername;database=databasename;uid=login;password=yourpassword”
sqlDbConnection = SqlClient.SqlConnection(sqlConnectionString)
sqlDbConnection.Open()
command = SqlClient.SqlCommand
command = sqlDbConnection.CreateCommand()
transaction = SqlClient.SqlTransaction
transaction = sqlDbConnection.BeginTransaction(“SampleTransaction”)
command.Connection = sqlDbConnection
command.Transaction = transaction
command.CommandText = “DELETE FROM you_table WHERE x = @Id”
command.Parameters.Add("@Id", SqlDbType.Int).Value = 100
command.ExecuteNonQuery()
transaction.Commit()
sqlDbConnection.Close()
OUT = 0
This was gold for me! After a bit of messing around with it I can now track and log all the information I want on Dynamo usage in our network. Work flawlessly with MSSQL Thank you!
I’m glad I was able to help you just a bit, next time I’ll try to add some comments to my code and specify the sections. Good luck.