Details: QuickBooks Enterprise 14.0 MS Access 2013
I have successfully imported several QuickBooks tables into MS Access however when I attempt to import some tables I get the following message: ODBC—call failed. [Sybase][ODBC Driver][SQL Anywhere]Permission denied:you do not have permission to select from “v_SalesOrder” (#-121)
I found this chart:
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.
Can anyone point me where I need to look?
In simple terms, the user (ie the database user id in your ODBC DSN or your connection string) you have used to connect to the SQL Anywhere database doesn't have SELECT rights on the table/view v_SalesOrder. You need to connect with a different user id with the appropriate rights or you could connect as DBA and grant the rights to the user id (e.g.
In SQL Anywhere (like most RDMSs) each database user can be given different rights to the various objects in the database - i.e. some users may be given all rights to everything, others just allowed to read data from a sub-set of tables.
What I can't tell you is whether QuickBooks will allow you to do that - it maybe that the user rights they are giving simply won't permit that. You would need to contact your QB support.