ODBC Connection for accounting software

[n3wbie]

there is an accounting package that share data over odbc connection to excel

can some one please help me use this odbc connection in autoit

odbc connection looks like this
 

XLODBC
1
DRIVER={Tally ODBC Driver};SERVER=(local);PORT=9000;
SELECT Ledger.`$Name`  FROM client.TallyUser.Ledger Ledger


$Name

if anyone can help i would be thankful

[mLipok]

Look in my signature for ado.au3

[n3wbie]

DRIVERS SEEM TO CHANGE IN MY CASE IE 

Tally ODBC Driver

BUT WHAT ABOUT DATABASE?

CAN YOU JUST WRITE A SHORT SNIPPET FOR JUST CONNECTING TO ODBC ON SAID CONFIG

[mLipok]

Download Ado.au3 UDF
Open ADO_EXAMPLE.au3
Add and try this function:

Func _Example_Tally()
    #cs
        https://www.autoitscript.com/forum/topic/184381-odbc-connection-for-accounting-software/
        DRIVER={Tally ODBC Driver};SERVER=(local);PORT=9000;
    #ce
    
    Local $sDriver = 'Tally ODBC Driver'
    Local $sServer = '(local)' 
    Local $sPort = '9000' 
    
    Local $sConnectionString = 'DRIVER={' & $sDriver & '};SERVER=' & $sServer & ';PORT=' & $sPort & ';'

    _Example_1_RecordsetToConsole($sConnectionString, "SELECT Ledger.`$Name`  FROM client.TallyUser.Ledger Ledger")
    _Example_2_RecordsetDisplay($sConnectionString, "SELECT Ledger.`$Name`  FROM client.TallyUser.Ledger Ledger")
    _Example_3_ConnectionProperties($sConnectionString)

EndFunc   ;==>_Example_Tally

 

mLipok

Edited September 7, 2016 by mLipok

[n3wbie]

Thanks it worked out great. can you also help me out with getting all table lists

m attaching a snapshot of how it looks in ms excel

[mLipok]

using ADO.au3 UDF
 

_ADO_Schema_GetAllTables($oConnection, 'dbName')