Graphics

 View Only
  • 1.  connect to SQL Server in script

    Posted 11-29-2017 16:06
    I need to query a SQL database from a scene script. What are possible ways of connecting to a SQL Server?
    I tried ADODB.RecordSet, but that does not seem to be available in the XPression scripting engine.
    I didn't see a DataLinq scripting object in the help file. I imagine there would be a way to use DataLinq in a script since it exists in Visual Logic.
    Anyone have any ideas?

    Jonas


  • 2.  RE: connect to SQL Server in script

    Posted 12-02-2017 17:15
    AFAIK, you need to set up the usual method of tying text objects to the query using normal datalinq functionality. Then, in your script, you can update the keys.
    #XPression