Squirrel Sql Client For Mac

Client
Related Reviews - more
email clients
telnet for mac
ftp clients
telnet clients
ftp software for mac
secure ftp clients
ftp client software
timers for mac
religion for mac
browsers for mac
war games for mac
chatting clients
mac games for kids
card games for mac
kids games for mac
recreation for mac
email tools for mac
board games for mac
other games for mac
action games for mac
arcade games for mac
gamble games for mac
online games for mac
puzzle games for mac
Home >Business >Databases & Tools > SQuirreL SQL Client for Mac
OverviewDownloadsBuyScreenshotsReviewsRatingsSecurityPublisherMore


Full size screenshot
SQuirreL SQL Client for Mac Publisher Description
The SQuirreL SQL client for Mac provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. It can also easily view and edit data in any JDBC-compliant database, work with multiple databases on both local and remote machines, use a single, consistent interface to work with different database engines..
Read more about SQuirreL SQL Client for Mac ..

an open-source Java SQL Client program for any JDBC compliant database.

Version:3.0.2Date Added:Jun 17, 2010
File Size:21.00MBDownloads: 392
License:Freeware
System:Mac OS X
Limitations:
Publisher:Colin Bell , More products
Requirements:

File size: 21.00MB
See rating details

Download SQuirreL SQL Client for free. A Java SQL client for any JDBC compliant database. SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of. My employer produces a simple, proof-of-concept HTML5-based SQL client which can be used against any ODBC data source on the web-browser host machine, through the HTML5 WebDB-to-ODBC Bridge we also produce. These components are free, for Mac, Windows, and more. Applicable to many of the other answers here - the Type 1 JDBC-to-ODBC Bridge that most are referring to is the one Sun built in to.

Nota al final añadir:
– append defaultSchema=pub to the end of the URL. Like:

jdbc:datadirect:openedge://localhost:5555;databaseName=testdb;defaultSchema=pub

Resolution
First download the installer file squirrel-sql-<version>-install.jar from http://squirrel-sql.sourceforge.net and install the SQuirreL SQL Client under Windows or Linux using the command: java -jar squirrel-sql-<version>-install.jar
During the graphical installation an installation path will be asked, as well as if a base or a standard install is wanted. Shortcuts to the application can be created on the desktop and in the Start menu. An uninstaller script is generated automatically and placed in the ‘Uninstaller’ folder of the SQuirreL installation directory.
After the installation of the SQuirreL SQL client the OpenEdge JDBC driver then needs to be added to the application by going to the ‘Drivers’ tab and clicking on the ‘+’ button. In the ‘Name’ field fill in ‘OpenEdge’ (and the OpenEdge version), in the field ‘Example URL’ fill in ‘jdbc:datadirect:openedge://localhost:5555;databaseName=testdb’ (for OpenEdge version 9.1E fill in ‘jdbc:JdbcProgress:T:localhost:5555:testdb’), in the field ‘Website URL’ fill in ‘www.progress.com’. Then go to the ‘Extra Class Path’ tab and click on the ‘Add’ button.
For the versions of OpenEdge 9.1E and 10.0B the file to add is /usr/dlc/java/jdbc.jar
For the versions of OpenEdge 10.1a, 10.1b, 10.1C and 10.2a the files to add are
/usr/dlc/java/util.jar
For the versions of OpenEdge 10.2B, 11.0, 11.1, 11.2 and 11.3 the file to add is /usr/dlc/java/openedge.jar
Once the jar files are added click on the ‘List Drivers’ button, in the Class Name field the following will appear under 9.1E and 10.0B: com.progress.sql.jdbc.JdbcProgressDriver , while under 10.1a, 10.1b, 10.1C, 10.2a, 10.2B, 11.0, 11.1, 11.2 and 11.3 the following will appear: com.ddtek.jdbc.openedge.OpenEdgeDriver
To then establish a connection to a database go to the ‘Aliases’ tab and click on the ‘+’ button, in the ‘Driver’ dropdown select the new driver entry you previously created, modify the ‘URL’ entry to match the hostname, port number and database name of the database you want to establish a connection to, and fill in the database ‘User Name’ and ‘Password’ fields.
To verify the entered alias settings click on the button ‘Test’, a popup will show up where you will need to click on the button ‘Connect’, a popup with ‘Connection successful’ will then appear. When the connection is successful press the button ‘OK’ the new alias is now added to the aliases list. Right click on the new alias created and select ‘Connect’ and press ‘Connect’. A query like ‘select * from PUB.customer;’ can then be entered, to run the SQL query click on the running man button or press the keyboard buttons Ctrl and Enter simultaneously.

(For OpenEdge versions prior to version 10.1A the DLC variable needs to be set before launching the SQuirreL SQL Client.)

Shortcuts to SQuirreL can be created on the desktop and in the Start menu. Subsequently, question is, how do I connect to SQuirreL SQL client? Connect to MySQL Data in Squirrel SQL Client. In Squirrel SQL, click Windows - View Drivers. Three days in january pdf free download. Click the plus icon to open the Add Driver wizard. In the Name box, enter a user-friendly name for the driver. Overview SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Getting Started and Introduction. The minimum version of Java supported is 1.8.x as of SQuirreL version 3.8.1.

Squirrel Sql Client 4.1 Release

DisclaimerThe origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an «AS IS» basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.