IB_WISQL, an IBConsole replacement GUI tool for 6.0 beta

By: Borland Staff

Abstract: The IBConsole program currently available for download is unfortunately a tool designed and developed for use with InterBase 6.0 versions that have implemented the Services API. Currently, that would exclude any Classic releases of the InterBase engine, n

Alert : The IBConsole program currently available for download is unfortunately a tool designed and developed for use with InterBase 6.0 versions that have implemented the Services API. Currently, that would exclude any Classic releases of the InterBase engine, namely the Linux 6.0 Beta Release.

Good News : There are currently two options available to the community for using the Linux InterBase 6.0 Beta Release.

  • The command line tools that ship with both the Linux and Windows 6.0 Beta Client packages will work with the InterBase Linux 6.0 Beta Server.
  • There also exists a powerful tool in the InterBase Community that can and does address the current need for a Windows graphical interface to the Linux InterBase 6.0 Server.
Written and offered as freeware by Jason Wharton, IB_WISQL.exe, is a very complete and useful tool. Jason's IB_WISQL, built with his IBOjects technology, has tons of great functionality. I personally found the Export, Datapump and QueryForms features very handy -- Markus.

IMPORTANT NOTE:
If using IB_WISQL with an InterBase Client (gds32.dll) less than 6.0 against an InterBase 6.0 Server you will not be able to use the new 6.0 datatypes.

If you would like to use the new InterBase 6.0 Server datatypes make sure that you install the InterBase 6.0 Beta Client for Windows.

Also be careful that when using IB_WISQL to make sure that the client dialect property is set to three (3) when connecting to and creating databases on an InterBase 6.0 Server.

Jason's IB_WISQL can be downloaded here.

Below please find Jason's feature listing.

  • Quickly and easily browse the data and metadata of your InterBase Classic and Superserver databases
  • Store multiple layouts for easy retrieval of preferences for many different projects. Screen shots...
  • Store multiple query forms for commonly accessed queries, for each layout preference
  • Create/Drop databases
  • Run scripts of multiple DDL & DML statements
  • Execute queries, view plans, search datasets, update/insert/delete records in-place.
  • Create/Alter/Drop tables, views, stored procedures, triggers, indexes, constraints, etc.
  • Create and set generators
  • Quickly view and modify source for stored procedures and triggers
  • Register and monitor events, logging time as they execute
  • Pump data between one database and another
  • Administer your server users (add, modify, delete) (IB 5.0 and above)

Server Response from: ETNASC03