MS SQL Server Connection

[blumi]

I want to use autoit to connect to a MS SQL server.

Is this possible with SQLite or do I have to use a SQL UDF?

[water]

I would use an UDF that is made for SQL server.
Check this list of UDFs in the wiki.

[Shrapnel]

I use this UDF and it works well for me http://www.autoitscript.com/forum/index.php?showtopic=51952 

I had to modify it a little bit to work with SQL 2012 using windows authentication... see my post here: https://www.autoitscript.com/forum/topic/51952-_sqlau3-adodbconnection/?do=findComment&comment=1094311

 

[blumi]

I want to use the _sql.au3 UDF, too.

What I miss, are some examples, not so good with SQL connections etc. in combination with autoit.

Tried some code, not sure, if correct, maybe someone will give me some help or some links where I can find some examples.

#Include <Array.au3>
#include <_SQL.au3>



$ScriptName = "SQL Connect"


$server     = "scm"
$db         = "CM"
$username   = "isu-sc2\report-reader"
$password   = "readerx1"




$ADODBHandle = _SQL_Startup()
If $ADODBHandle = $SQL_ERROR then Msgbox(0 + 16 +262144,"Error",_SQL_GetErrMsg())

$con = _SQL_Connect($ADODBHandle,$server, $db, $username, $password)

$data = _SQL_Execute(-1,"SELECT * FROM CompanyName;")





_SQL_Close($ADODBHandle = -1)

 

[mLipok]

did you use my modified version:

 

[Zedna]

Here is very simple (minimal) example for getting data from MSSQL databaze in AutoIt by using ADO (part of system) without any UDFs.

 

[riyanmarge]

Check this one, more about...SqlServer Connection

Riyan