Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can a multi statement SQL script access several database connections and/or databases?

April 26, 2017database databases multi Script sql

0

Posted

Can a multi statement SQL script access several database connections and/or databases?

1 Answer

0

Posted

No! The multi SQL statement execution facility in DbVisualizer Personal can only access database objects in one specific database connection. 6.11 My XP box suddenly freeze! Several users have reported that their XP (and also Win2000) machines freeze when using DbVisualizer. (“The only workaround is to power off the box!”) The root of this problem is pre Java 1.4.1_02 versions in combination with some graphics cards. Please read more in the bug report 4713003 at http://www.sun.com for possible workarounds. The preferred solution to this problem is to upgrade the Java VM to JRE/JDK 1.4.1_03 from Sun. If upgrading the JVM is not an option then the workaround suggestions in the bug report tells how to pass properties to the Java VM. For DbVisualizer you must add these to the dbvis.