Hello all -

I am working on a Visual FoxPro 9.0 SP2 application hitting on Microsoft SQL Server using Remote Views and SPT. The Remote Views are all set to share a connection (verified via Query > Advanced Options). The name of the Connection is CONNECTION_1100 for all of them.

The original application was making separate connections (and then calling a Stored Procedure to grant appropriate roles) for EACH option within the application. I have refactored this to make only one connection (using the above name) at application start-up and set the role there; all options now use the connection handle created and stored at application launch as needed.

The problem I am having with the remote views is that although the named connection in the views is the same as above, a second (third, etc.) connection is made when the view is opened.


To troubleshoot this outside the application I run the following code, which opens two of the views.

USE rv_sheet_column
? CURSORGETPROP("ConnectHandle","rv_sheet_column"), CURSORGETPROP("ConnectName","rv_sheet_column")
SELECT 0
USE rvl_product
? CURSORGETPROP("ConnectHandle","rvl_product"), CURSORGETPROP("ConnectName","rvl_product")

What I get is:
1 CONNECTION_1100
2 CONNECTION_1100

Note that if I don't select a new work area (via SELECT 0) the second view does indeed use the same connection handle.

I've not heavily used Remote Views in the past, so I appreciate any help. What do I need to do to ensure all views use the same connection created at application start-up?

Thanks.