Realm Id

[FordCPA]

I have an app that I developed to automate data entry into lacerte, we have been using it since 2019 and i have the Lacerte ODBC drivers to do it. I can push numbers to any year except 2024, i get this message. "Unable to perform authorization check. The LacerteTax application must be setup and have resolved the proper realm id." Lacerte hasn't been able to help me, it has not happened in the last five years, so we are just trying to get to the bottom of it.

[TGDonovan]

Did you install the latest driver. I haven't tested, but they released version 1.0.0.473 this week, and I believe you need that.

[kamprich]

Hi, I was going to suggest the same things.     I was using version 1.0.0.467 of the SDK and I kept on getting "Cannot find encrypt4.dll" (or something like that).    I wrote an ODBC program to create a customer questionnaire based on previous year tax returns.    I installed the 1.0.0.473 release this morning and all the problems went away and I was able to query thousands of clients and get their data with no problems.    

Also I found that they have changed how your access Series = 1 info.    The codes have changed and I only found this by using the ODBC interface with Excel.   I had to change the query:   

[TGDonovan]

I would like to know more about "Also I found that they have changed how your access Series = 1 info.    The codes have changed and I only found this by using the ODBC interface with Excel.   I had to change the query:   "

I am getting a Unhandled managed exception now that I hadn't been getting in the past when running an ODBC query against Data1-Client.

[kamprich]

I have attached an example.

[TGDonovan]

Thank, appreciate your sharing.

[kamprich]

Hi,

Usually, if I don't get the data field I want, I use the Excel interface with ODBC to dump the table.  This is described in their SDK documentation.

Since Intuit doesn't really supply any table documentation, I found that this is the only way to find certain information.

Good Luck!

Rick

[AndresVTB]

I'd be really interested in this program if you could share more.

[kamprich]

The Excel-ODBC example is in the SDK document:   https://developer.intuit.com/app/developer/logged-in-content/Lacerte_SDK_Developer_Instructions.pdf