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 : Server side error updating rowSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Server side error updating row 
 Author   Message 
  Bill Semitekol 
  
 Group: Members 
 Posts: 4 
 Joined: 2008-10-05 
 Profile
 Posted : 2008-11-03 09:34:38

I am running Alpha 5 V-9 with an active link to Quick Books Pro 2008
When I try to update a record in the Alpha 5 default browse screen I get the following error message:

Server side error updating row.
database API specific error

Your database has returned the following error code and description to Apha Five.
Consult your data base documentation for further information.

11015 - '[QODBC] Expected lexical element not found:)
SQL state is: 42000'
refresh the data to see the current server values.

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-03 22:24:44
"Expected lexical element not found" is basically a syntax error, but you haven't provided the SQL statement you are trying to execute. 

  Top 
  Bill Semitekol 
  
 Group: Members 
 Posts: 4 
 Joined: 2008-10-05 
 Profile
 Posted : 2008-11-04 10:05:03

I have created an active link between Alpha 5 and Quick Books and have used the Test Connection successfully.

Following is the Connection String that was created by Alpha 5:
 {A5API=QuickBooks,FileName='C:\Documents and Settings\WCS\WCS Documents\HISA\Quick Books 2008\HISA.QBW',UserName='Admin',Password='×±¹ãó²°°´'}

Then I selected on the Customer, CustomerType and CustomField tables to view and the Active_Link Tables were created in the Alpha Data Base with  Updateable set to Yes on all 3 tables.

I can load the Customer: Default browse table and view all of the records.  I get the error message when I try to change data in any of the fields.
I get the same error message in all 3 of the tables I have tried to link.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-05 10:19:13
Correct, every table seen in QODBC has some read-only columns because things like ListID and TxnID are reserved as they are generated by QuickBooks. See: Where are the schema rules for using QODBC? How do I use sp_columns?  

  Top 
  Bill Semitekol 
  
 Group: Members 
 Posts: 4 
 Joined: 2008-10-05 
 Profile
 Posted : 2008-11-06 09:24:05

I followed your steps and was able to run the VB demo on Quick Books without any problems. 
I than ran Alpha 5 V-9  to load the customer data base from Quick Books and successfully made an active link.
After opening the default table in Alpha 5 I could view all 1,800 customer records from Quick Books.  When I try to update just one data field in the file I get the following error message:

Server side error updating row.
database API specific error

Your database has returned the following error code and description to Apha Five.
Consult your data base documentation for further information.

11015 - '[QODBC] Expected lexical element not found:)
SQL state is: 42000'
refresh the data to see the current server values.

Can I update data in Quick Books thought the Alpha 5 data base.  I was under the impression that I could.  I also understand that I should not be able to change data in some of  the fields.

 

 

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

Try looking at: Alpha 5 to Quickbooks 2004 preimer 

For support on Alpha 5 however you need to contact them directly.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to