>>You mean something like:

>>local loAdapter
>>loAdapter = newobject('ca_name','my_ca_classlib[.vcx]')
>>loAdapter.CursorFill()

>>Of course, once loAdapter goes out of scope the CA is destroyed and the cursor is closed unless you call the CursorDetach method before it loses scope.
>
>Yes that is kind of what I'm looking for where do i put the connection string? Using sqlserver with ado.

I have demo TestADO.PRG file on my web-site that you can download. It is in the CASamples ZIP file under the FoxPro Tools link at http://www.mctweedle.com