SQL Anywhere database - Editing VFP in ASA

Author

Editing VFP in ASA

Willie van Schalkwyk

2005-06-22, 1:23 pm

Hi to all
I need to edit a foxpro table and not sure 100% how to do it. I can view the
data but not update it. Herewith what I did from the start:
I setup an ODBC connection in my ODBC mamanger.

In ASA console, under the Remote Servers, I setup a generic server with the
name of the ODBC connection name.

In the Tables tab I add a new Proxy table. All data is displayed when
viewing the data under the Data page tab.

When I try to change information the following error occurs:

[Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Server
'FoxPropMast': [Microsoft][ODBC Visual FoxPro Driver]Command contains
unrecognized phrase/keyword.
SQLCODE: -660
SQLSTATE: HY000

Any idea what I am doing wrong?

Thanks
--

--------------------------------------------------------------------------------
Willie van Schalkwyk
Managing Director
USP Designs (Pty) Ltd

E: willie@cyberprop.com
T: +27 11 955 9100
S: 086 112 9237
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za

USP Designs (Pty) Ltd is Proudly South African!

This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.

Willie van Schalkwyk

2005-06-24, 3:23 am

Anybody get any idea?
If not, who will be able to help me?

Thanks

--

--------------------------------------------------------------------------------
Willie van Schalkwyk
Managing Director
USP Designs (Pty) Ltd

E: willie@cyberprop.com
T: +27 11 955 9100
S: 086 112 9237
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za

USP Designs (Pty) Ltd is Proudly South African!

This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
"Willie van Schalkwyk" <willie@cyberprop.com> wrote in message
news:42b9a91d@forums
-1-dub...
> Hi to all
> I need to edit a foxpro table and not sure 100% how to do it. I can view
> the data but not update it. Herewith what I did from the start:
> I setup an ODBC connection in my ODBC mamanger.
>
> In ASA console, under the Remote Servers, I setup a generic server with
> the name of the ODBC connection name.
>
> In the Tables tab I add a new Proxy table. All data is displayed when
> viewing the data under the Data page tab.
>
> When I try to change information the following error occurs:
>
> [Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Server
> 'FoxPropMast': [Microsoft][ODBC Visual FoxPro Driver]Command contains
> unrecognized phrase/keyword.
> SQLCODE: -660
> SQLSTATE: HY000
>
> Any idea what I am doing wrong?
>
> Thanks
> --
>
> --------------------------------------------------------------------------------
> Willie van Schalkwyk
> Managing Director
> USP Designs (Pty) Ltd
>
> E: willie@cyberprop.com
> T: +27 11 955 9100
> S: 086 112 9237
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
>
> USP Designs (Pty) Ltd is Proudly South African!
>
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>

Greg Fenton

2005-06-24, 9:23 am

Willie van Schalkwyk wrote:
>
> [Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Server
> 'FoxPropMast': [Microsoft][ODBC Visual FoxPro Driver]Command contains
> unrecognized phrase/keyword.
> SQLCODE: -660
> SQLSTATE: HY000
>

Please always post the version and build number of SQLAnywhere that you
are using (e.g. for 9.x, use the command "dbeng9 -v")

From my interpretation of the above error message, it appears that
VFP's ODBC driver cannot handle some of the commands coming from ASA.

You might try setting the CIS_OPTION in SQLAnywhere to have the Remote
Data Access layer (on which Proxy Tables work) output debug information
to the database console. This might help determine what is going on.

In the SQLAnywhere 9.x online docs, see:

ASA Database Administration Guide
Database Options
Alphabetical list of options
- CIS_OPTION option [database]

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links