Script with SQL for second database

You will need to set up a separate Connection in JScript.

We talked about this a while back - the basic jist is in the following Topic…

This discusses connection to MSSQL and MySQL Databases using a connection made in JScript using IIRC ActiveX Object. Today, there will be better ways than ActiveX, like using host.lib or host.type helpers, but the theory is similar. If you stick with MSSQL, you will probably be better off since C# and .NET will have native support for MSSQL and that is where host.lib/type come in.

1 Like