Alpha Video Training
Results 1 to 9 of 9

Thread: QODBC

  1. #1
    Member
    Real Name
    keith
    Join Date
    Aug 2009
    Location
    New England
    Posts
    24

    Default QODBC

    I have done a search and have not found the answer to this question
    the salesman at Alpha told me if I used Alpha Five V9 I could connect directly to Quickbooks. But I seem to be finding, when I try to connect that I now need a special driver, is this correct? and at an additional cost?

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: QODBC

    Enterprise versions of Quickbooks have the QODBC driver included...

    Are you sure you do not have the QODBC driver? If you do then Alpha can use it to connect easily (read only unless you have upgraded your QODBC driver to a read/write version).
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  3. #3
    Member
    Real Name
    keith
    Join Date
    Aug 2009
    Location
    New England
    Posts
    24

    Default Re: QODBC

    We use quickbooks premier mfg. 2009 edition and we only need to read from QB

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,594

    Default Re: QODBC

    Quote Originally Posted by ketoman View Post
    We use quickbooks premier mfg. 2009 edition and we only need to read from QB
    Then you need to get a copy of QODBC to read from QuickBooks. There is a 30 day trial on QODBC.com

    QuickBooks needs QODBC to open it's data to the rest of the world. Alpha uses ODBC technology to read the QODBC provided data.

    An interesting aspect of the QuickBooks SDK (of which QODBC is based) is that QODBC is really talking to the QuickBooks program rather than directly to the QuickBooks data. That makes for some interesting ramifications - control by QuickBooks of what data can be read or written to. And ease of data entry for programs that are adding data to QuickBooks and still getting the QuickBooks validation routines.

    You may also want to look at QReportBuilder - which is an Alpha application designed to report from QuickBooks.
    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.

  5. #5
    Member
    Real Name
    keith
    Join Date
    Aug 2009
    Location
    New England
    Posts
    24

    Default Re: QODBC

    Thanks for the info, one thing I was wondering, is if We have the QB running in the front office and I want to build my Alpha app. from my laptop thru our net work do I need the server version of QODBC or just the standard version. After development they will be on the same pc.

  6. #6
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,594

    Default Re: QODBC

    Quote Originally Posted by ketoman View Post
    Thanks for the info, one thing I was wondering, is if We have the QB running in the front office and I want to build my Alpha app. from my laptop thru our net work do I need the server version of QODBC or just the standard version. After development they will be on the same pc.
    You can do either.

    The newer versions of QODBC supports the Intuit RDS (Remote Data Services?), but if you are going to have QuickBooks and Alpha on the same machine (tried and true method) then I'd build to that environment.

    That means loading QuickBooks on your laptop and running both there.

    Copy your QuickBooks company file to the laptop also and you'll have a nice dev/testing environment that isn't interfering with production and will be easy to move to the production machine when ready.
    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.

  7. #7
    Member
    Real Name
    keith
    Join Date
    Aug 2009
    Location
    New England
    Posts
    24

    Default Re: QODBC

    Thanks guys
    you have been most helpful

  8. #8
    Member
    Real Name
    keith
    Join Date
    Aug 2009
    Location
    New England
    Posts
    24

    Default Re: QODBC

    I have everything connecting when QB file is open, but when closed I cannot access account even though I have setup customer file as shared and set it in the data sources for use any ideas?.

  9. #9
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,594

    Default Re: QODBC

    Quote Originally Posted by ketoman View Post
    I have everything connecting when QB file is open, but when closed I cannot access account even though I have setup customer file as shared and set it in the data sources for use any ideas?.
    Here is a link to your other thread, which when implemented should fix this problem....
    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, 03:19 PM
  2. QODBC with Microsoft Vista
    By 411tech in forum QReportBuilder
    Replies: 6
    Last Post: 10-07-2007, 03:49 PM
  3. QODBC R/W - anyone used this?
    By Steve Wood in forum Alpha Five Version 7
    Replies: 11
    Last Post: 06-01-2007, 11:43 PM
  4. Invoices into QuickBooks via QODBC
    By TTI in forum Alpha Five Version 8
    Replies: 3
    Last Post: 04-11-2007, 10:48 PM
  5. A5 - qodbc - Quickbooks
    By David in forum Alpha Five Version 7
    Replies: 6
    Last Post: 05-14-2006, 11:57 AM

Bookmarks

Posting Permissions

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