>Thanks Bob,
>
>What I'm doing now is this:
>
>1) I get my "main" connection using sqlpassthru
>
>2) I override the existing connection (let's call it "db_conn") on the database container this time "recreating" it with the connection string from "main" connection.
>
>3)I open a remote view so I can get a connection handle value for "db_conn".
>
>Now I have 2 connections. I disconnect the "main" connection and just copy the connection handle created from "db_conn" to the main connection and I'm set, just have one connection.

Ok, unless you mean that in Step one you get the information to create connection two for a sql table I don't understand why you bother "recreating" the the "db_conn" connection rather than just setting the ConnString property using code like:

DBSETPROP('db_conn',"CONNECTION","ConnectString",cConnStr)

BOb