Next is setting the $SQLConn variable for connecting to the Database.
All I am doing is running a SELECT Statement and then outputting the result to the console.
As you can see the first parameter value for the Open function is the SQL statement itself and the second parameter is the SQL Connection variable. Please see below, my script was able to execute the SELECT Statement.
If you want to run commands such as UPDATE, INSERT or DELETE. All you will need to is the $SQLConn variable with the Execute method, which looks like $SQLConn.Execute("UPDATE table SET column1 = 'value' WHERE column1 IS NULL").
Click here for the source code.
