MS SQL Server connection with AutoIT

[v4nandu]

Hi Team,

 

I am looking for a solution to connect MS SQL DB with an AutoIT bot. But I am getting error. I have <MSSQL.au3> & <SQLite.au3> and did not work...  

 

Local $sqlCon = _MSSQL_Con("IP Address","Username","password","DB_Name")

    $sqlCon = ObjCreate("ADODB.Connection")
    $sqlCon.Open(Provider="{SQL Server}"; Data Source="IP Address"; User ID="Username"; Password="password"; database="DB_Name";)

Please suggest

 

[Jos]

Welcome,

18 minutes ago, v4nandu said:

But I am getting error. I have <MSSQL.au3> & <SQLite.au3> and did not work...  

That doesn't help us to understand unless you give us all the details!  
Also show the/a runnable script so we can see what you are doing.

Jos

[Earthshine]

i really hope you are not sending the literal "Username" and the literal "Password" as the actual username/password in that connect string

Edited December 9, 2021 by Earthshine

[v4nandu]

$DSN = 'DRIVER={SQL Server};SERVER=' & $sServer & ';DATABASE=' & $sDatabase & ';UID=' & $sUID &';PWD=' & $sPWD & ';'
$oConn = ObjCreate ("ADODB.Connection")
$oConn.ConnectionTimeout = 3 ; default is 15 s (must be supported by data provider DSN)
$oConn.Open($DSN)

Thanks Jos for the quick reply... I got the issue solved using this MS SQL connection - AutoIt General Help and Support - AutoIt Forums (autoitscript.com)

Earthshine - that was nice...

 

Thanks team