>i trying to do it without dsnname only servername is should enough and also view should parametric view . in this situation how would be your SPT syntax's with above connection string. and also when you need update some fields how can we use yor CA Class for this.
>
>if give me a sample for both it would be very appreciated.

Oh, for the Connection String for SQL Server see:

Re: SQL Connection without ODBC DSN Thread #814550 Message #814552

As for the CA class, just run my CABuilder PRG from the VFP 8 Command Window. After the VCX is used, create a test form and open the DE. Right-click and select Builder. Click the Cursors tab, then click the Add button. Select any CA from the VCX the Builder created for you. Set the name and Alias properties if needed. Then click OK. After the CA is added to the DE, you can delete all the code from all the methods in the CA that the builder automatically added. This code is already in the CA class.

More detailed instructions are in the comments at the beginning of the CABuilder.prg file.