>Hello,
>I set up a remove view to a SQL Server table. In code I do an INSERT INTO 'remote_view' to insert into the table. This seems to keep the SQL connection open. Is there a way to close the connection after I do this?

A remote view requires an open connection. You have to close remote view first before closing an ODBC connection it uses.