Icon of program: Interactive SQL

Interactive SQL for Windows

By Nick HristovFreeUser Rating

Key Details of Interactive SQL

  • Run queries and SQL commands.
  • Last updated on 7/12/2013
  • There have been 4 updates
  • Virus scan status:

    Clean (it's extremely likely that this software program is clean)


Enlarged image for Interactive SQL

Developer's Description

Run queries and SQL commands.
InstallationCopy and unzip in a folder.For Unix based OS run mkfile(./mkfile). It will create isqlc.sh, which is the start up file for the application.

Installing Database DriversCopy jar file(s) into root folder or modify DRIVER_CLASSPATH to point to jar's location and start application.

For legal reasons, Database Drivers are not supplied with the application. They can be downloaded from the links below.

WindowsUsage: isqlc.cmd [[user password] [-i file]]

Unix basedUsage: ./isqlc.sh [[user password] [-i file]]

user - database user namepassword - user's passwordfile - file containing SQL queries

When -i is used, no banner is displayed and the application exits after the batch is complete.

ConfigurationJAVA_HOME - location where JRE is installedDRIVER_CLASSPATH - location of database driver(s)CONFIG_LOCATION - location of config.properties file

Config.properties filemax_text - display size of character fieldscomment - line comments markerbatch_separator - delimiter between commandsdriver - database driver classconnString - java connect string

Example:max_text=60comment=--batch_separator=;driver=com.microsoft.sqlserver.jdbc.SQLServerDriverconnString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabase

Block comments marker is the standard /* */.

Database Drivers DownloadMSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.htmlSybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnectMySQL: http://dev.mysql.com/downloads/connector/j/


Explore More