[TriLUG] OT: QuickBooks ODBC

[Stan B. Briggs]

brian,

i never put any of this code into production. i was able to use the
sdktest.exe and the samples in the xml samples directory to read and
write data but the whole thing was just too cludgy. typical (in my
humble opinion) of the kind of thing that intuit would do so that they
can say that they have an API.

i never was able to do anything that even closely resembled accessing
from a remote machine or from a different OS platform.

note 1:
let me know if you have any successes with this effort. i still use
quickbooks and would be interested to know if anything that resembled a
true API was out there for the product.
note 2:
have you tried any of the more open source accounting products
(sql-ledger and gnucash come to mind).

stan

On Thu, 2004-07-29 at 11:57, Brian Henning wrote:
> Your timing is impeccable...  I just (looked for and) found the QuickBooks
> SDK today.  I can't get it to work at all, though.  Running the example
> given on the Intuit Developer website results in an error message stating
> sdkcore.dll doesn't have a certain entrypoint..  Now, I had to copy several
> DLLs from the QB installation directory into the working directory of the
> sample program in order to get it to find the DLLs at all..  Could the fact
> that it's a copy rather than the original be causing such an error?  Here's
> the actual text of the error (which pops up in a modal dialog box):
> 
> java.exe - Entry Point Not Found
> (X) The procedure entry point ?append at sdk_string@@QAWAAV1 at PAD@Z could not be
> located in the dynamic link library sdkcore.dll.
> [OK]
> 
> Clicking OK of course brings the process to a close with a
> java.lang.UnsatisfiedLinkError exception and a backtrace:
> 
> Exception in thread "main" java.lang.UnsatisfiedLinkError:
> C:\java\sdkjcalls.dll
> : The specified procedure could not be found
>         at java.lang.ClassLoader$NativeLibrary.load(Native Method)
>         at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560)
>         at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1485)
>         at java.lang.Runtime.loadLibrary0(Runtime.java:788)
>         at java.lang.System.loadLibrary(System.java:834)
>         at RequestProcessor.<clinit>(RequestProcessor.java:21)
>         at simpler.communicateWithQB(simpler.java:157)
>         at simpler.main(simpler.java:47)
> 
> I realize that this is getting WAY outside the typical realm of the TriLUG
> list, and I'll be happy to take my problem elsewhere if anyone takes issue.
> 
> Thanks,
> ~Brian
> 
> ----- Original Message ----- 
> From: "Stan B. Briggs" <stan at StanBriggs.com>
> To: "Triangle Linux Users Group discussion list" <trilug at trilug.org>
> Sent: Thursday, July 29, 2004 11:44 AM
> Subject: Re: [TriLUG] OT: QuickBooks ODBC
> 
> 
> > brian,
> >
> > there is a quickbooks SDK. if you can't find it on the intuit site (or
> > in google) then contact me off-list and i'll get a copy of it to you.
> > it's free. it's not extrememly easy to use. it does have examples in
> > c++, vb, and xml.
> >
> > i can assure you that it's not exactly what you are looking for. (ie,
> > the quickbooks file that you're accessing must be open for the api to
> > work. ['least that's my experience.]).
> >
> > stan
> >
>