Alpha Video Training
Results 1 to 11 of 11

Thread: Qb Odbc Stopped Working

  1. #1
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    546

    Default Qb Odbc Stopped Working

    Enterprise version of QB 11 the ODBC driver is updating a passive link table in Alpha of invoice line items based on a SQL statement, the SQL statement has a Greater then Date e.g. date > 01012010.

    It stopped working? It stops at January 1, 2011 last records in?
    Any ideas? I checked there are records after that date.
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


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

    Default Re: Qb Odbc Stopped Working

    Nick

    Find the *.opt files in a hidden directory for QODBC - usually under the My Documents folder.

    This is an optimizer table that QODBC uses and can get corrupted (rarely).

    Each company file has an .opt file that can be deleted and will automagically get rebuilt.

    Let me know if that solves the problem.

    The file can't have it's location changed - delete and let QODBC rebuild instead.
    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.

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

    Default Re: Qb Odbc Stopped Working

    date > 01012010
    and this date format worked? My limited knowledge only knows of 2 formats which are 2011-01-01 and {d'2011-01-01'}. What type of SQL definition is being used--am thinking Native as I have only used Portable and Stored Procedure.
    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
    __________________________________________




  4. #4
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    546

    Default Re: Qb Odbc Stopped Working

    Al, no opt files?

    Have this in the error log:
    2011-03-09 00:32:54 QODBC Ver: 10.00.00.265 *********************************************************************************************************************
    IsAService: False
    Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040421, This application is not allowed to change its authentication preferences unless QuickBooks is running with the Administrator logged in.
    Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
    I was logged in as Admin too?
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


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

    Default Re: Qb Odbc Stopped Working

    Nick

    The first time you connect to a QB company file, you must be logged in as the QB admin to allow any application to 'talk' to QB. That's an INTUIT requirement.

    Doesn't sound like that has happened yet...

    http://qreportbuilder.com/connect.html
    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.

  6. #6
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    546

    Default Re: Qb Odbc Stopped Working

    Ok so you asked me to look for opt files NONE.

    I just provide it connected to the customer file and did indeed pull new records correctly file count was only 1366.

    When I go to pull in from the invoice line file it stops at 383709 records.??? and stops at 1/1/2011???????

    Ok why? Any ideas on this, is there a record problem?
    Meaning a limit some how? With the driver?

    I have got to get this working again, suggestions please...

    I thought it was not on the right company, maybe copied etc. not case as proven.

    here is the sql:
    SELECT CustomerRefListID, CustomerRefFullName, TxnDate, RefNumber,
    BillAddressAddr1, InvoiceLineItemRefListID, InvoiceLineItemRefFullName,
    InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineUnitOfMeasure,
    InvoiceLineRate, InvoiceLineAmount FROM InvoiceLine WHERE TxnDate >
    {2010-06-01}

    Ok so I changed the select statement to be WHERE TxnDate > {2011-01-01}
    it shows 24 records that are 11/12/2016 which are in the data base and should not but are there but will
    not show 2011 records that are there and in front of them....????
    IDEAS?

    If I remove the where clause and empty the db it still skips the 2011-01-02 and beyond.
    I thought it was the number of records so I made the where 2010-11-01 got all records up to 2010-01-01 nothing else and of course 2016 records. I am thinking the driver is confused I am going to have the customer delete and reenter those records with correct date. But what happens if I get the same results? again IDEAS?
    Last edited by NicholasWieland; 04-12-2011 at 10:36 PM. Reason: more info
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


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

    Default Re: Qb Odbc Stopped Working

    Nicholas,
    Unless you have specifically turned off optimization either in the QODBC setup tabbed dialog or in your SQL definition (which you have not), then there should be an *.opt file for each company file you have refreshed (where the * is the project name).

    As Al indicated, your symptoms can very well be associated with a corrupt .opt file and is the easiest/fastest possible cause to check out---well, if you can find the .opt file of course!

    Checking the QODBC Setup Optimizer tab, mine (as yours also should) indicated the *.opt files should be located at the following pathway.
    %UserProfile%\QODBC Driver for QuickBooks\Optimizer

    This, in my case, translates to:
    C:\Documents and Settings\Owner\Application Data\QODBC Driver for QuickBooks\Optimizer
    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
    __________________________________________




  8. #8
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    546

    Default Re: Qb Odbc Stopped Working

    Mike,

    Thanks I do not know why the search did not find the opt files?
    Anyway thanks for the path on it. Found it and deleted it was quite large 2.8 gig. the customer file is only 1366 records but the invoiceline is like 800,000 I think.

    So it is rerunning and 1st time takes quite a while thereafter 10 minutes, so lets see and thanks atleast I am moving forward....
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


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

    Default Re: Qb Odbc Stopped Working

    Quote Originally Posted by NicholasWieland View Post
    Thanks I do not know why the search did not find the opt files?
    Hidden is the imperative word and not the default search option.
    Quote Originally Posted by Al Buchholz View Post
    Find the *.opt files in a hidden directory for QODBC - usually under the My Documents folder.
    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.

  10. #10
    Member NicholasWieland's Avatar
    Real Name
    Nicholas Wieland
    Join Date
    Apr 2008
    Location
    Huntington, NY
    Posts
    546

    Default Re: Qb Odbc Stopped Working

    Is there a newer driver????
    driver is 10.00.00.265?

    This is nuts just stopped working I can not get any data after 383709 records and with a date after 1/2/2011
    Nicholas Wieland
    LedgerSuite.com Corp
    nnw@edfi.net
    http://www.ledgersuite.com


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

    Default Re: Qb Odbc Stopped Working

    Quote Originally Posted by NicholasWieland View Post
    Is there a newer driver????
    driver is 10.00.00.265?
    Yes, you need the 11.0.0.277 driver to read QB 2011

    What version of QRB do you have? 277 is part of QRB 2011 (ie based on Alpha 10.5)

    You should also run the verify of QB data to make sure there is not a problem within the QB company file. QB - File - Utilities - verify data
    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. alpha5 stopped working
    By richard2007 in forum Alpha Five Version 9 - Desktop Applications
    Replies: 7
    Last Post: 09-07-2009, 05:06 AM
  2. Lookup stopped working???
    By Alastair in forum Alpha Five Version 9 - Desktop Applications
    Replies: 16
    Last Post: 12-27-2008, 12:18 PM
  3. xdialog stopped working
    By reynolditpi in forum Alpha Five Version 9 - Desktop Applications
    Replies: 11
    Last Post: 07-24-2008, 07:06 AM
  4. stopped working
    By Schulzie in forum Alpha Five Version 4
    Replies: 7
    Last Post: 01-14-2005, 06:23 AM
  5. HELP! My fieldrules seem to have stopped working!
    By MIKKI BREAUX in forum Alpha Five Version 1
    Replies: 0
    Last Post: 03-11-2003, 03:31 PM

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
  •