tally integration from access is not working from tally 4.9.3 onwards

Discussion in 'Tally Developer' started by anagha, Jul 5, 2016.

    
  1. anagha

    anagha New Member


    Dear Sir,

    I have created ODBC as below to fetch data from MS-Access. It is working fine till Tally Erp 4.9.1, but giving error as ' invalid no of steps' from Tally 4.9.3 version onwards. please help

    ODBC code which is working till 4.9.1

    [Collection : Led Coll From Access]
    ODBC : "Driver={Microsoft Access Driver (*.mdb)};Dbq=D:\Tallyint\Mydb.mdb;Uid=;Pwd=;"
    SQL : Select * From Ledtest
    Keep Source : ().
    Client Only : Yes

    [Collection : AccessColl]
    Source Collection : Led coll From Access
    Compute : AnaBank : $_2
    Compute : AnaDate : $_3
    Compute : AnaTno : $_4
    Compute : AnaAcc : $_5
    Compute : AnaChq : $_6
    Compute : anaAmt : $_8
    Compute : anaNarr : $_9
     
    zakirhossain_diu likes this.


  2. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Invalid no of steps Means

    Unable to communicate with Acces mdb through ODBC

    Check Bitness of Windows/MS Office/Tally

    MS OFFICE, WINDOWS, TALLY all should be in eithor 32 bit or 64 bit


    Download and install AccessDatabaseEngine for 32 bit

    Download and install AccessDatabaseEngine_x64 for 64 bit

    n Check
     


Share This Page