Hi Mark,
i know your class . but i didn't test it . exactly i need a like solution short,fast,and without odbc connection . for eg with this connectionstring i can connection to remote data

* connectionstring for Pervasive SQL Server
lcserver="w2000srv"+".1583"
lcdsn="xl3"

	"DSN=&lcdsn;ServerName=&lcserver;ServerDSN=&lcdsn;UID=;PWD=;ArrayFetchOn=1;ArrayBufferSize=8;TransportHint=TCP:SPX;TranslationDLL=C:\PVSW\Bin\w32btxlt.dll;DecimalSymbol=,;"

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.

TIA