Troubleshooting a Squirrel SQL Client
Squirrel SQL Client is a free graphical-user interface for viewing the component structure of databases. You can browse the available data in tables, create new queries or edit existing ones. Squirrel uses Java in order to run, and many issues encountered by users are as a result of Java problems. If you're experiencing difficulties running Java on your machine, there are a few simple fixes you can try.
Other People Are Reading
Instructions
-
-
1
Check your Java version by launching the GUI and selecting "About" from the "Help" menu on the top bar. Version 1.3 is the minimum required to run Squirrel, but some users have reported instability with this edition. If you experience problems, visit the official Java website to download the latest version. The 1.4 version is recommended for the best performance.
-
2
Click on the "Windows" menu form the top bar, and select "View Drivers." This will open the JDBC Driver List window where you can view all the installed drivers, and their current status. A green check mark means the driver is properly installed and working correctly. A red cross means there is a fault. If any of your drivers are marked with a red cross, check that they're in the correct directory. You can check the location by right-clicking the problem driver and checking the file path. It should be inside the "SQuirrel SQL Client" install folder. If necessary, move the .jar file to the folder using Windows navigator.
-
-
3
Navigate into the Squirrel folder structure and locate the "SQLAliases23_treeStructure.xml" file. Right-click on it and select "Properties" from the contextual menu. Check the file size. If it displays 0Kb, highlight it and press "F2" to rename it. Add ".bak" to the extension, minus the quotes and press Enter to confirm it. Restart SQuirreL and try it again.
-
1
