I have a PB app using SQLAnywhere 10. The app runs fine in
development and fine from the executable on the development
machine. When I deploy it to another machine, I get syntax
errors in my SQL statements (either embedded or on a
datawindow). SQLSTATE 37000, Syntax error near 'item' on
line 1. Since this works on one machine and not the other,
I am assuming this has something to do with the ODBC
connection or setup. Can someone help? Thanks.

Robb,

You need the PBODB105.ini (digit part of file name dependent on PB
version) file to be included in your deployment. Possibly you had to edit
this on your developer machine, as Sybase marketing decided to rename the
product from Adaptive Server Anywhere to SQL Anywhere, and thus PB was not
able to know the database specifics of ASA10. So, copying this file from
your developer PC to the deployment PC into the directory hosing the PBDK
files could solve your problem.

Frank

On Tue, 30 Oct 2007 14:32:49 +0100, Robb <Marr> wrote:

That corrected the problem. Thank you.