Alpha Video Training
Results 1 to 2 of 2

Thread: QODBC, QBES8, AlphaFive V6 integration

  1. #1
    Real Name
    Janine Freitas
    Join Date
    Nov 2007

    Default QODBC, QBES8, AlphaFive V6 integration

    I have an AlphaFiveV6 app using QODBC Enterprise Edition and QBES 8 for server. This app (reads data from QB) was working fine with QODBC Full Version, QBES 6 until the client upgraded his QB POS to the lastest version. Then the ADO commands to read data from QuickBooks stopped working.

    The QODBC Test Connection works, the QODBC VB Demo works and even the ODBC Import Genie in Alpha Five works, but when I copy the import genie Xbasic code to a script file and run the script file, it doesn't work.

    At first I thought the QODBC driver was somehow corrupt, because the app worked fine on my computer at home. But QODBC support said it's fine.

    Since the app stopped working, I went ahead and allowed the client to upgrade his QBES 6 to 8 and we installed the correct QODBC Enterprise Edition. The problem remains though. Then I was thinking AlphaFive somehow became corrupted, until I did further testing on my computer at home. I also upgraded to QBES 8 for SERVER. Now my app doesn't work either. Although I don't have QBPOS installed, I'm now wondering if it has something to do with the server versions of QBES and QBPOS.

    I created 2 trace files - one running odbc_import_table from the import genie, the second running the same command from a script file. I've included the second so you see where the program stops working (although the program never ends, it just hangs and I have to end the process).

    The following is the code that works from the import genie, but not from a script:
    odbc_import_table("ODBC","QuickBooks Data","C:\Documents And Settings\Doublej\My Documents\Instrument Rental Application\qb customers2.dbf","SELECT * FROM CUSTOMER","","")

    The following is the trace file when the program doesn't work:
    Database: .
    DSN: QuickBooks Data
    OpenMode: F
    UseDCOM: N
    IBizRemoteConnection: N
    IBizRemoteURL: http://localhost:2080
    IBizRemoteUserName: admin
    IBizRemoteAskPassword: Y
    IBizRemoteConnectionTimeOut: 120
    IBizRemoteForce2002_2003: N
    IBizOEConnection: N
    IBizOELoginAsk: Y
    IBizReconnectionDelay: 0
    ColumnNameLen: 50
    UseCaseSensitiveRefNumber: Y
    OptimizerOn: N
    OptimizerDBFolder: C:\Documents and Settings\Owner\Application Data\QODBC Driver for QuickBooks\Optimizer
    OptimizerCurrency: C
    OptimizerDirtyReads: N
    OptimizerUpdateSync: N
    OptimizerEncrytionOn: Y
    ShortCircuitOptimizeFields: Y
    UseIterators: Y
    IteratorChunkSize: 500
    IAppLaunchQBUI: N
    IAppAutomaticLogin: Y
    IAppReadOnly: Y
    IAppAllowPersonalData: Y
    ConvertToLongVARCHAR: FALSE
    MaxLONGVARCHAR: 4096
    Convert To LONGVARCHAR: N
    Max LONGVARCHAR: 4096
    OleInitialize - Returned OK
    Logged In User: Owner
    Is a Service: No
    Registration Name:
    QODBC Version:
    DLL: C:\WINDOWS\system32\fqqb32.dll
    Driver Name: FQQB32.DLL
    Process Count: 1
    Thread Count: 0
    OpenMode: Follow Company
    Include Raw: No
    Version Type: QuickBooks Enterprise Read Only Desktop Edition
    Access Method: QBXMLRP2.DLL (IAuth2)
    Thread ID: 2540
    SDK Module: QBXMLRP2.DLL (IAuth2)

    it stops there and doesn't go any further.

    I'd rather not have to upgrade AlphaFive unless it's guaranteed to solve the problem, but what is puzzling me is why it stopped working after the client upgraded his POS and hadn't touched quickbooks enterprise, the qodbc, or alpha.

    I'm submitting to this forum, because it seems to be the most appropriate place to discuss qodbc and integration with quickbooks. Please let me know if this should be somewhere else.

    Janine Freitas

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Delavan, Wisconsin

    Default Re: QODBC, QBES8, AlphaFive V6 integration


    Did the location of the QB company file change after the upgrade of QB?

    Check that the DSN: QuickBooks Data is pointing at the right place.

    I've been trying to contact you after Mark gave me your name, but I'm not being successful. I just replied to your email from the board with my cell number. Call that number please or send me a number that I can call you with.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. QODBC
    By dbny in forum Alpha Five Version 8
    Replies: 4
    Last Post: 12-02-2007, 04:19 PM
  2. QODBC with Microsoft Vista
    By 411tech in forum QReportBuilder
    Replies: 6
    Last Post: 10-07-2007, 04:49 PM
  3. QODBC R/W - anyone used this?
    By Steve Wood in forum Alpha Five Version 7
    Replies: 11
    Last Post: 06-02-2007, 12:43 AM
  4. A5 - qodbc - Quickbooks
    By David in forum Alpha Five Version 7
    Replies: 6
    Last Post: 05-14-2006, 12:57 PM
  5. QODBC Quickbooks query
    By pstaver in forum Alpha Five Version 6
    Replies: 3
    Last Post: 03-30-2005, 01:10 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts