How To Keep DB Connection To the Other Sql Editors,Command Editors, etc...

[rayma1]

Hi Marco,

Greetings!

Hope you could help me out. The scenario is this.

I have multiple SQL editors opened (Sample below).

SQL Editor 1 => connected to DB1
SQL Editor 2 => connected to DB2
SQL Editor 3 => connected to DB3
.
.
.
SQL Editor ? => connected to DB?

Whenever I change DB connection, it changes also the other editors that are not currently active in my screen.

I tried playing around with the :

TOOLS => PREFERENCES => CONNECTION
=> PIN WINDOW CONNECTION BY DEFAULT (ON/OFF)

but with no luck.
How can I achieve this?

Regards,
rayma1

 

[patch]

Have you 'pinned' the connections? Check the little icon in the statusbar of the window.

 

[Hilarion]

The "Pin window connection by default" only affects newly open windows, so if you did play with it after opening the windows, then it had no effect on them. The only way you can change the window behavior in that aspect, after it was open, is to manually pin (or unpin) that window.
If you'll check the option "Pin window connection by default", then your new windows will start as pinned, so they will not change their connection when you switch the main connection.

At least that's how it's documented and how works for me. Maybe you are doing something different, as you wrote that you "change DB connection" and not "change main DB connection". Each of those windows' connections is a DB connection, so from what you wrote I can't be sure which connection (and how) you are changing, so can't say why it changes connections of all the windows.