>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only