i am also trying to do this with SPT.

myconn=sqlstringconnect("driver={Tally ODBC driver};server=local;port=9000")
wait wind myconn  && showing 1
if myconn<0
   wait wind 'error ' nowa 
   retu 
else
   wait wind 'Connected'  nowa 
endif

myresult=sqlexec(myconn,'select ledger.$name, ledger.$parent from ledger',[mycursor])

wait wind myresult  && Showing 1 and brow the data perfect as MEMO field.

if myresult<0
   wait wind 'Result Error'
else
   sele mycursor    && this is showing all the data 
   brow 
endif
myresult=sqlexec(myconn,'insert into ledger (ledger.$name, ledger.$parent) values ([Apple],[Sundry Debtors]))

wait wind myresult  && Showing 1 but not inserting the data into ledger table.

if myresult<0
   wait wind 'Result Error' nowa
else
   wait wind 'Record inserted ' nowa
endif


myresult=sqlexec(myconn,'select ledger.$name, ledger.$parent from ledger',[mycursor])

wait wind myresult  && Showing 1 but not showing the records i inserted above.

if myresult<0
   wait wind 'Result Error'
else
   sele mycursor    && this is showing all the data 
   brow 
endif

i think this ODBC connection accept data only in XML format.
can you please show some code for send XML data to ODBC.

this ODBC accept SOAP + XML, please where i can find more about SOAP + XML .

you can see more detail at :

http://www.rtslink.com/index.html

warm ragards,
mk.