Server side error updating row |
Author |
Message |
|
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.
|
|
|
|
Tom |
|
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. |
|
|
|
|
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-05 10:19:13 |
|
|
|
|
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-06 09:32:57 |
|
|
|