[RBASE-L] - Re: Second connection

[Dawn Hast]

Can you sconnect to the second db and sattach the necessary tables to update? 

-------------- Original message from "jan johansen" <[EMAIL PROTECTED]>: --------------

Group,

 

I have a process that archives from one database to the another.

I have a step that checks for the number of connections before I start the process.

However the process can take 10-15 minutes and it never fails, someone

will connect to either of the databases in the middle of the processes.

 

Although I use SET MULTI OFF, when I disconnect from database 1 and connect

to database 2, database 1 becomes available for connections because I am now

in database 2.

 

Anyone have any slick tricks to open a second connection with code so that with

SET MULTI OFF I have the only connections allowed to the database and then

shut down both connections after I am done?

 

Jan