I have a problem, I need only one connection in all my application (it is very expensive to have an engine with more than 60 PC on line and more than 120 connections open). But, I need to use a numbered connection because I use stored procedures in MSSQLSERVER 6.5 (1 connection), and I use remote views (another connection). The views have the shared connections option set to .T..
In the application I have first SQLCONNECT() and then a USE of sqlview.
My question is: How can I do to get the sqlview to use the connection already open?
Thanks in advance.