>OK, I did this, and the result is -1. My Client Access connection is configured as Read/Write (all SQL statements allowed). I'm a little confused.....this same connection allowed me to update an AS400 file, but will not allow me to write to an AS400 file. I turned on trace & the sql.log file shows a message that the "token . was not valid".
>
>Maybe this log file will help me resolve the problem. I would appreciate any further advice. Thanks for your help!
The only other thing I can recommend is talk to your DBA/network admin...there may be further security issues that need to be resolved.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
