Results 1 to 1 of 1
  1. #1
    HappyJohn is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    2

    Lightbulb Importing QuickBooks Tables: Sporadic ODBC Call failed Issue

    I am attempting to import QuickBooks tables using the built in Intuit ODBC Driver. Some tables I can import smoothly while other tables fail to import. The message I get when a table fails to import is as follows:
    ODBC—call failed.
    [Sybase][ODBC Driver][SQL Anywhere]Permission denied:you do not have permission to select from “v_SalesOrder” (#-121)

    I don't know what Sybase is. And since I have a QuickBooks admin login, I would like to think I have the maximum QuickBooks security level. I am having difficulty in understanding why I'm able to import some tables with zero issue while other tables give me the above error message.


    On this page I found the -121 error code:
    http://dcx.sybase.com/1200/en/saerro...base-code.html
    The Sybase details say:
    Permission denied: %1
    Error constant SQLE_PERMISSION_DENIED
    ODBC 2 state 42000
    ODBC 3 state 42000
    Parameter 1 Description of the type of permission required.
    Severity 16
    SQLCODE -121
    SQLSTATE 42501
    Sybase error code 262

    Probable cause

    You do not have the required permission to perform the specified action. The message specifies the actual permission required and the object being acted upon.



    UPDATE: I found this ODBC diagnostic website that gives me some more details.
    http://www.easysoft.com/developer/in...html#AppendixA

    In Appendix A under "SQLSTATE 01" it says:
    SQLSTATE = 42501
    Error = Base table or view already exists
    Can not be return from = *StatementText contained a CREATE TABLE or CREATE VIEW statement, and the table name or view name specified already exists.

    For the code below, I don't know if this is correct to look at since the matrix I attached says 'ODBC 2 State = 42000' and ODBC 3 State = 42000. Anyway the description is congruent w/ my permission denied message says:
    SQLSTATE = 42000
    Error = Syntax error or access violation
    SQLExecDirect = *StatementText contained an SQL statement that was not preparable or contained a syntax error.
    The user did not have permission to execute the prepared statement associated with the StatementHandle.




    Details:
    *Using QuickBooks Enterprise 14 (admin login)
    *ODBC driver = Intuit ODBC Driver (read only)
    *Windows-7 (64 bit)
    *MS Access 2013
    *ODBC novice
    *I was using the QODBC driver (30-day trial) however the expiration ran out, I attempted to uninstall it though I still get QODBC messages telling me my subscription ran out. I was able to import almost every table with the exception of the "Transaction" table.
    *With the QODBC driver, I was able to "see" about 150 QuickBook tables that I could import/link.
    *With the Intuit ODBC driver, I am able to "see" about 500 QuickBook table that I could potentially import/link however depending on the table I attempt to import I'll get the above ODBC call fail..
    Last edited by HappyJohn; 10-09-2014 at 08:17 AM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ODBC-Call Failed
    By gviau in forum SQL Server
    Replies: 1
    Last Post: 07-05-2014, 10:25 AM
  2. ODBC -- Call Failed error
    By Coffee in forum Access
    Replies: 3
    Last Post: 07-08-2011, 10:34 AM
  3. ODBC Call Failed after Office upgrade
    By DanJV in forum Access
    Replies: 2
    Last Post: 05-25-2011, 01:48 PM
  4. ODBC--call failed
    By TCB in forum Access
    Replies: 4
    Last Post: 04-28-2011, 08:23 AM
  5. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 09:32 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
  •  
Other Forums: Microsoft Office Forums