>I am currently using FoxPro 7 and the Remote views. The Remote views have the Share Connection option which allows the users to only have one connection to the backend database, in our case SQL Server. We are looking to upgrade to 8.0 and want to use the cursor adapter but cannot find a setting similar. Does anyone know how to ensure that you only have one connection to the backend database with the cursor adapter?
>
>Tracey Krumroy

Create your connection programmatically. SQLSTRINGCONNECT has a 2nd parameter to indicate a shared connection [.T.]. Then use that connection handle as the DataSource in your CAs. If you are using ADO, you do somewhat the same thing, you just set your DataSource to the ADO connection object.

Take a look at my CA VCX Builder that has all source code and extensive comments in the CABuilder PRG file on using the builder and the VCX it creates for you. The builder will create a VCX with a CA for every table in your SQL Server database, a VFP DBC or an Oracle database. All you have to do is populate a few properties and your off. Get this free builder by clicking the FoxPro Tools link at:

http://www.mctweedle.com