Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Query fails from VBA in Excel - TMP folder requiredSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Query fails from VBA in Excel - TMP folder required 
 Author   Message 
  George Stossel 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-03-03 
 Profile
 Posted : 2007-11-20 07:13:24

We have implimented a module in Excel that does a query of our QB 2007 Pro Customer data to add or update customer information.  We implimented this using the ADO example from the website and it was working under QODBC 7.0 but we can not make it work under 8.0.   The connection string sucessfully opens the file but the open for the recordset gives an error "ODBC driver does not support the requested properties.".  We put the exact same SQL statement into the VB6demo program opening the exact same System DSN connection and it works fine.

I suspect some change in library references is required, but have no idea how to debug the exact nature of the problem.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-11-20 08:03:10
Try looking at the end of the QODBC Message and SDK Message logs in the QODBC Setup Screen for more detail on the actual error. 

  Top 
  George Stossel 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-03-03 
 Profile
 Posted : 2007-11-21 07:04:04

From QODBCTRA.txt:
2007-11-20 14:00:11 QODBC Ver:  8.00.00.237 *********************************************************************************************************************
IsAService: False
Error Code: 1
SQLOptimize_TraceDatabaseStatus step:
SELECT * FROM "SQLite_MASTER" ORDER BY "tbl_name" ASC, "type" DESC
SQL logic error or missing database

From QODBCLOG.txt:
2007-11-20 14:00:11 QODBC Ver:  8.00.00.237 *********************************************************************************************************************
IsAService: False
Error Code: 1
SQLOptimize_TraceDatabaseStatus step:
SELECT * FROM "SQLite_MASTER" ORDER BY "tbl_name" ASC, "type" DESC
SQL logic error or missing database

From ODBC SQL.LOG:
e               ab8-d6c EXIT  SQLExecDirectW  with return code -1 (SQL_ERROR)
  HSTMT               034A2100
  WCHAR *             0x0328A790 [      59] "SELECT * FROM Customer WHERE (AccountNumber LIKE 'WW1333%')"
  SDWORD                    59

  DIAG [S0000] [QODBC] Unable to do ORDER BY (11046)

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-11-21 09:27:13

Try rebuilding you optimizer Customer table by doing:

SELECT * FROM Customer verify WHERE (AccountNumber LIKE 'WW1333%')

 

  Top 
  George Stossel 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-03-03 
 Profile
 Posted : 2007-11-22 09:20:46

We have the Optimizer feature turned off.

After a bit of further investigation we determined that the "Unable to do ORDER BY" error was related to a problem with access to the TMP Environment Variable's destination folder.  Once this was corrected all SQL access from VBA under Excel was restored.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to