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 : Weird error on update queriesSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Weird error on update queries 
 Author   Message 
  Cathy Boland 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-12-12 
 Profile
 Posted : 2008-01-08 15:29:50

I've developed an application in VB.NET V2.0 that is updating the customer table in QuickBooks Enterprise Edition V8.  I had everything tested out and working fine.  I pulled in the latest client Quick Books .QBW file into my copy of Quick Books and started up my app for the final data integration.  During the process I got this error I had never seen before: 

ERROR [HY010] [Microsoft][ODBC Driver Manager] Function sequence error

An example of one of the update sql statements would be: UPDATE Customer SET JobDesc = '4'
WHERE ListID='800013C7-1198210737'

I'm completely baffled on this one.  Can you help?


 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-01-08 17:12:22

Please review the QODBC and SDK Message log in the Messages Tab of the QODBC Setup Screen for the true QODBC error.

If you have never used the client's QBW file before, then you will have to go through the How do I connect to QuickBooks for the first time? procedure and setup: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? to call the company file directly.

 

  Top 
  Cathy Boland 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-12-12 
 Profile
 Posted : 2008-01-09 04:21:33
I can connect to the QBW file just fine.  I'm not getting the error on every read or write.  There are no QODBC messages to review and no SDK messages that are errors. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-01-09 09:11:25

Do queries using VB Demo still work? What happens when you change back to the previous .qbw file? Have you checked your connection string or that company file is setup in the DSN is correct for the clients .qbw file?

 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to