[Solved] MS SQL Express 2014 - Connect

[argumentum]

I'm with MS SQL Express 2014.
Went to the wiki - Databases_and_web_connections but I can't find a way =/

the strings I've got are:

ODBC;DSN=eFilmWorkstation;Trusted_Connection=Yes
ODBC;DSN=eFilmWorkstation;UID=sa;PWD=eFilmWS30
"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';"

A working example ? ( that would run if you had the db )
Or, advise in a UDF to use and how to use it ?

I don't care to write, just to read.

Thanks
 

Edited March 14, 2018 by argumentum

[argumentum]

found the solution  

#include <_sql.au3>
#include <array.au3>

Opt ("trayIconDebug",1)

Msgbox(0,"","Start the Script and load the error handler")
 _SQL_RegisterErrorHandler();register the error handler to prevent hard crash on COM error

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

If _sql_Connect($oADODB,"localhost\SQLEXPRESSEFILM","eFilmWorkstation","sa","eFilmWS30") = $SQL_ERROR then
    Msgbox(0 + 16 +262144,"Error 2",_SQL_GetErrMsg())
    _SQL_Close()
    Exit
EndIf

Local $aData,$iRows,$iColumns;Variables to store the array data in to and the row count and the column count
$iRval = _SQL_GetTable2D(-1,"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';",$aData,$iRows,$iColumns)
If $iRval = $SQL_OK then _arrayDisplay($aData,"2D  (" & $iRows & " Rows) (" & $iColumns & " Columns)" )
_SQL_Close()

 

[mLipok]

Try my ADO.au3 udf. 

Look in my signature.