MS SQL connection
Hi,
For a few days I'm trying connect to MSSQL Server. My test environment is easy: my computer on W10 with Autoit and second machine Windows 2016 Server with MS SQL 2016 Standard Edition.
When I use PowerShell, there is no problem. I can connect to this sql and do query.
When I use Autoit I get connection error.
1. I used ADO.au3 UDF from mLipok and I get:
2. I use _sql.au3 from Chris Lambert and I get
What I do wrong?
What is the easiest
Here is more general example showing working with ADO directly without any includes:
; https://www.w3schools.com/asp/ado_intro.asp
$objErr = ObjEvent("AutoIt.Error","MyErrFunc")
$sServer = 'server1'
$sDatabase = 'master'
$sUID = 'admin'
$sPWD = 'pwd'
$DSN = 'DRIVER={SQL Server};SERVER=' & $sServer & ';DATABASE=' & $sDatabase & ';UID=' & $sUID &';PWD=' & $sPWD & ';'
$oConn = ObjCreate ("ADODB.Connection"
