Retreiving data from SQL

[Queener]

Using the MSSQL.udf

I asked this question once, but haven't had a chance to reply to my old post so posting a new one instead of bouncing the old post.

I'm trying to retrieve data from my database in Microsoft SQL Server 2014. When I tried the code below; empty message box return and no error approaches.

$Connection = _MSSQL_Con($ServerAddress, $ServerUsername, $ServerPassword, $ServerDBName)
    $Testquery = _MSSQL_Query($Connection, "SELECT User_ID From Banker where Manager like '%Jason%'")
    msgbox(0, "Test", $Testquery)
    exit

Edited October 6, 2016 by Queener

[mLipok]

Try my ADO.au3 in my signature.

 

[Queener]

Tried and getting error:

"C:\Program Files (x86)\AutoIt3\Include\ADO.au3" (769) : ==> The requested action with this object has failed.:
$oConnection.Open($sConnectionString)
$oConnection^ ERROR

 

Could it possibly be the DSN because I used the default on your example.

[mLipok]

Show how You tried.

[Queener]

I got it to work with this:

 

$sprovider= "sqloledb.1"
$sServer = "Queener\SQLEXPRESS"
$sUser = "sa"
$sPassword = "9999"
$sDatabase = "Bankz"

Local $sConnectionString = 'provider=' & $sprovider & ';SERVER=' & $sServer & ';UID=' & $sUser & ';PWD=' & $sPassword & '; initial catalog=' & $sDatabase

Edited October 6, 2016 by Queener

[mLipok]

This snippet do not show how you use any functions.
CN string looks ok.

Edited October 6, 2016 by mLipok