I am accessing remote views via ODBC with a named connection in the VFP database. I thought I would get only one connection handle for the named connection, but it appears each time I open a remote view I get a new connection handle. I vaguely remember seeing something in the documentation about sharing connection handles.

I would appreciate any information you could give me on how connection handles work. Would a shared connection handle greatly slow down data access? What is the most efficient way to open and close multiple data handles? What impact does the multiple connection handles have on the SQL Server database?


Thank you,
Garry