>I need to know whether or not a SQL connection that is opened by a remote view is closed when the view is closed.
>
>Also, is there any way to monitor connections to the SQL Server?

Well, how about monitoring the SQLCONNECT return values. In my experience when you SQLConnect, you get a handle starting from 1, and incrementing by 1 with each concurrent connection.

So, 1) get a handle, 2) run your view, 3) get another handle and ensure that it is just the first handle + 1.

This assumes that remote views use handles in the same way as SQLConnect.