- Mark as New
- Permalink
- Report Inappropriate Content
I recently discovered the Lacerte SDK and am excited by the promise. I am having no trouble reading data, but cannot get data written.
I am using Python with the pyodbc driver to connect to the database.
For example, trying to add to the Dividend Screen (Series=13) a value for Capital Gains (Code=3) for an existing entry (Prefix=1)
import pyodbc cnxn = pyodbc.connect(r'driver=LacerteDSIIDriver; DataDir=L:\19TAX\IData;', autocommit=True) cursor = cnxn.cursor() cursor.execute("INSERT INTO [ZZZDEV2-Detail] (Series, Prefix, Code, Suffix, StateAbbr, Amount, Description) VALUES (13,1,3,1000,'IL',69,'DAN');") cnxn.commit()
This executes without error, but no data is written to the table.
The Lacerte SDK manual indicates the ODBC driver can write to the Detail table, but I could not find any examples.
Has anybody written to the Detail table? Care to show the code?
- Mark as New
- Permalink
- Report Inappropriate Content
For those following along at home, this was fixed in the 1/20/20 update of the SDK. I can now read and write Details.
Thanks!
- Mark as New
- Permalink
- Report Inappropriate Content
@djb I'm curious if the pyodbc module still functions for you when connecting to the DB?
I am attempting something similar but it fails at Registration portion of the connect method.
If I'm not mistaken, the OAuth-type authentication was a recent addition and I'm wondering if it's worth my time to troubleshoot (Or if it's even possible without using .Net).
- Mark as New
- Permalink
- Report Inappropriate Content
For future reference, the Python version needs to match the ODBC version (32bit vs 64bit)