Hi everyone,
With info from the board - I wrote the following
#include <array.au3>
#include <sql.au3>
Func connectDB()
$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.Open("DRIVER={SQL Server};SERVER=Server1;DATABASE=DB1;UID=sa;PWD=password;")
Return $sqlCon
EndFunc
$conn=connectDB()
$results=$conn.Execute ("SELECT * FROM mytable",@LF)
msgbox(0,"test",$results)
The connection work fine - I tested
I beleive the script is running
But how do I show the results of my s