Welcome back! Ask questions, get answers, and join our large community of tax professionals.
  • Sign In
  • Elevate 2026 Pencil Banner
    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    ODBC export error with latest Lacerte update

    MikeCodesStuff
    Level 2

    I'm using pyodbc to pull return data from all modules in order to aggregate reports/dashboards and as of a Lacerte update this morning I'm getting this error:

     

    pyodbc.Error: ('HY000', "[HY000] [Lacerte][CLIDSI] (90) Unhandled managed exception caught: System.Exception: Exception of type 'System.Exception' was thrown. (Stack Trace:    at Interop.ClientDataAccess.ITableAccess.MoveToNextRow()\r\n   at f.MoveToNextRow()\r\n   at Simba.CLIDSI.CLIDSIResultSet.Move(CLIDSIResultSet* , DSIDirection in_direction, Int64 in_offset)) (90) (SQLFetch)")

     

    I did not personally do the update so I don't know how far back it went (likely August at the earliest)

    and it only errs on the Individual and Partnership modules

     

    any insight/help would be much appreciated!

    4 Comments 4
    john_samuel
    Employee
    Employee

    We are working on making changes to SDK, we will share the latest SDK in sometime. Please email to LacerteEncryption@intuit.comso that we will share SDK with you. 

    John Samuel
    0 Cheers
    Reply
    DatabaseRobert
    Level 5

    Please post the updated SDK to the dedicated resource page, so that we are not tied to having to email somewhere.
      https://developer.intuit.com/app/developer/lacerte-sdk/docs/lacerte-get-started



    Robert

    0 Cheers
    Reply
    MikeCodesStuff
    Level 2

    the updated SDK (1.0.0.417) solved the problem!

     

    thanks, gang

    0 Cheers
    Reply