Software

urSQL was first developed in 1996 as a replacement for Microsoft SQL Server's isql_w utility. Used as an in-house tool for development, urSQL quickly became a favorite with Windows programmers and the need to access different RDBMSs became clear.

urSQL functionality was expanded to include MSSQL 7.x, MySQL 3.23, and Paradox.

See below for brief version notes:

• Version 2.0.1.163 - September 8, 2005
  • Fixed problem when connecting to MySQL 4.1+ (Authentication)
  • Modified underlying MySQL connection library
  • Addressed some compatibility issues between MySQL 3.x and 4.1
• Version 2.0.1.160 - August 24, 2005
  • Fixed problem when connecting to PostgreSQL (tables not displayed)
• Version 2.0.1.159 - August 10, 2004
  • Fixed problem with MySQL 4.x Build Script(s) (when using ursql native connection)
• Version 2.0.1.158 - April 27, 2004
  • Fixed problem with MySQL # comment on own line
  • Fixed problem with urSQL-MySQL null default database
• Version 2.0.1.157 - April 22, 2004
  • Fixed problem with MySQL ODBC default database
  • Fixed problem with urSQL MySQL default database
  • Added functionality to use User/Password from MySQL ODBC DSN (if not saved by urSQL)
• Version 2.0.1.156 - March 30, 2004
  • Fixed problem with MS Access ODBC connections
  • Fixed problem with urSQL Access ODBC/ADO connections
  • Fixed urSQL MySQL to properly use custom-assigned port
  • Other minor enhancements
• Version 2.0.1.155 - March 11, 2004
  • Added "Show View Source" option for MSSQL Views
  • Minor enhancements of MSSQL features
  • scc (mark)
• Version 2.0.1.153 - 154 - Circa February 20, 2004
  • Development builds.
• Version 2.0.1.152 - February 12, 2004
  • Enhanced column and procedure searching
    • Added "Find in Procedures" to search within procedure code (MSSQL)
    • Enhanced search results - clicking locates/activates object
    • Prepended "database." to MySQL column search results
• Version 2.0.1.151 - February 10, 2004
  • Modified "Save As" to append default extension of .sql
  • Fixed minor problem with Auto-size columns option
  • Modified default handling of stored proc Execute
• Version 2.0.1.150 - February 9, 2004
  • Major release with many changes.
  • Updated support for native MySQL.
  • Updated support for ADO connections.
  • Added urSQL native connections option.
  • Added feature for auto-restore grids.
  • Modified main registry key to be urSQL.
  • Modified initialization key from intialization.
  • Added extended logging feature.
  • Fixed problem with saving of code templates.
  • Fixed problem with saving of auto replace options.
  • Modified MSSQL Stored Procedure handling:
    • List parameters on select.
    • Added Execute template.
    • Added Alter option.
    • Added Show Source option.
    • Miscellaneous enhancements.
  • Added "Table Quick View"
  • Enhanced help browser.
  • Added setting for default quote character.
  • Added (column popup) option to "insert at cursor".
  • Fixed problem with base font persistence.
  • Enhanced handling of multiple result sets (MSSQL only).
  • Added feature for searching history list.
  • Modified print preview initialization to prevent dialog when no default printer is configured.
  • Removed DLL list from Submit Incident info.
  • Added option to include log when submitting incident info.
  • Modified multiple query parsing.
  • Many other minor changes, enhancements, and fixes.
• Version 2.0.1.144 - February 2, 2004
  • Many changes. See notes for 2.0.1.150 above.
• Version 1.0.1.135 - November 3, 2003
  • Modified connectivity to use native drivers (no BDE)
  • Added native support for connecting to MySQL (without ODBC)
  • Changed all MSSQL connectivity to use ADO
  • Added support for MSSQL User-Defined Functions
  • Added column search feature (Find column...)
  • Added basic support for threaded queries
  • Added SQL Messages window [pane]
  • Added extended structure info for MSSQL tables
  • Added procedure search feature (Find procedure...)
  • Redesigned Settings tab layout
  • Added stored procedure filters (MSSQL only)
  • Added configuration option for Settings tab position
  • Added configuration option for Tables tab position
• Version 1.0.1.108 - May 26, 2003
  • Updated to properly recoginze MySQL ODBC driver 3.51
• Version 1.0.1.107 - July 29, 2002
  • Fixed problem with "rows affected".
  • Updated disconnect routine to clear "rows affected" status message.
  • Added path of file opened for the current page to the main caption.
  • Added basic Export Options dialog for setting export specifics.
  • Other minor changes/enhancements.
• Version 1.0.1.106 - April 30, 2002
  • Fixed problem with System DSNs (potentially addresses incidents #0094, #0099, and #0081
  • Fixed problem that caused encryption update (from prev version).
  • Modified text of query message to "clear this memo" from "clear this message".
  • Removed single quote comment character (') from SQLScript.txt (introduced erroneously in 1.0.1.105).
• Version 1.0.1.105 - April 29, 2002
  • Fixed comment problem [urSQL Incident #0100]
  • Modified default color scheme to be black on white.
  • Added code to put ESC x2 cut on the undo stack.
  • Updated all methods of submission to be consistent.
• Version 1.0.1.104 - January 18, 2002
  • Modified internal variable names and reg handling.
• Version 1.0.1.103 - January 4, 2002
  • Modified default query exporter behavior to omit quotes from NULL dates.
• Version 1.0.1.102 - December 3, 2001
  • Updated scripting to work with MSSQL Server 2000
  • Added scripting options "Version 7.x Only", "No Collation", and "Extended Property"
  • Updated scripting window to render properly in Windows XP
• Version 1.0.1.101 - November 26, 2001
  • Added support for scripting multiple MSSQL tables
  • Added advanced scripting options for MSSQL scripting
  • Added splitter control to Main Tables List
• Version 1.0.1.100 - November 25, 2001
  • Modified Databases combo box to persist current DB name
  • Changed default database handling to use ODBC DSN default over MS SQL Server default
  • Modified change database processing (use db_name)
• Version 1.0.1.99 - October 23, 2001
  • Modified settings to prevent invisible History list [urSQL Incident #0091]
  • Added HistoryList pop-up menu and options to remove single items in history.
  • Added confirmation when closing history.
  • Added new scripting option to allow MySQL tables to be saved as MS Access CREATE TABLE scripts.
  • Added new scripting option to allow MS Access tables to be saved as MySQL CREATE TABLE scripts.
  • Added code to enclose MySQL database names with ticks (` `) if version of MySQL is 3.23.6 or higher. [urSQL Incident #0093]
  • Modified MySQL Admin functions to use index instead of Field (potentail problem with MyODBC SQLDescribeCol option returns ".Field" instead of "Field").
• Version 1.0.1.98 - October 19, 2001
  • Intermediate build.
• Version 1.0.1.97 - September 11, 2001
  • Modified Databases drop-down to allow manual entry of db name
• Version 1.0.1.96 - June 7, 2001
  • Enhanced Edit & Search menu items dependent on active tab
  • Fixed potential memory leak when opening multiple tabs
• Version 1.0.1.95 - June 4, 2001
  • Fixed problem with "Select All" and DB Memo
  • Added Replace dialog
  • Changed SubmitIncident tab to allow Pasting into Summary memo
  • Fixed minor problem with SubmitIncident special characters
  • Added code to remember last email address used to submit incident
• Version 1.0.1.94 - June 3, 2001
  • Fixed urSQL Incident #0087
  • Indirectly fixed urSQL Incident #0088
  • Disabled the "Include Keys" option when building MySQL scripts (keys are always included).
  • Added option to automagically display a build script in the query memo.
• Version 1.0.1.93 - May 29, 2001
  • Added feature to copy the tables list to the clipboard (Tables popup menu)
  • Added feature to copy columns list to the clipboard (Fields popup menu)
  • Addressed urSQL Incident #0086
  • Fixed Edit->Copy to copy from the Active Memo
  • Fixed Edit->Paste to paste to the Active Memo
  • Fixed Edit->Clear Window to clear only the Active Memo
  • Activated registration verification
• Version 1.0.1.92 - April 25, 2001
  • Fixed problem with default character values in MySQL scripting
  • Enhancements to QueryExport (escape strings & insert null keyword)
• Version 1.0.1.91 - April 22, 2001
  • Enhanced MS Access structure viewing
  • Added basic table scripting feature for MS Access
  • Fixed query export (@create insert) to escape strings
  • Added feature to display MS Access index info
• Version 1.0.1.90 - April 12, 2001
  • Enhanced/Modified statistics to include urCommands
  • Added code to make sure database is disconnected on close
  • Fixed batch query processing to refresh dataset if necessary
  • Changed stats to store seconds for Elapsed Time and Cummulative Time
  • Added code to remove old stats info when upgrading from 1.0.1.88 or 1.0.1.89
  • Added option to include stats when submitting incident
  • Added button to allow direct saving of debug info without submitting
  • Other minor enhancements
• Version 1.0.1.89 - March 1, 2001
  • Fixed problem with MySQL Scripting
  • Enhanced statistics and logging features
  • Fixed error-handling when restoring grids
  • Enhanced grid save/restore features
  • Added sub menu with saved grids to ResultsGrid popup
  • Fixed memory leak in query export
  • Fixed memory leak in fields list
  • Addressed several other minor issues
• Version 1.0.1.88 - February 25, 2001
  • Addressed urSQL Incident #0082
  • Added UserNullFilter to allow user-specified NULL indicator (urSQL Incident #0083)
  • Enhanced MSAccess Structure info
  • Added Stats/Log Tab
  • Added Statistics Grid and supporting functions
  • Added Session Log (TreeView) and supporting functions
• Version 1.0.1.87 - February 23, 2001
  • Enhanced export variable handling (VarParser)
  • Enhanced export functionality
  • Added export feedback info to status bar
• Version 1.0.1.86 - February 20, 2001
  • Changed Export features to work with MSSQL 7.x
  • Enhanced Multiple Query support
• Version 1.0.1.85 - February 19, 2001
  • Modified SQL parsing engine to allow escaping \;
  • Enhanced the Query Export features
  • Enhanced Create Insert Export features
• Version 1.0.1.84 - January 27, 2001
  • Added customizable hotkey/function key for executing queries
  • Added functionality to support setting bookmarks in main query tab
  • Enhanced inter-program navigation for main tabs (Alt+Q,etc)
  • Re-added basic Find and Find Again support
• Version 1.0.1.83 - January 21, 2001
  • Changed MySQL Database Enumeration to get DB names by index
  • Added error-handling to ignore empty result sets for non-query sql
  • Fixed problem with ADO connection string when connecting to MSSQL 7.x
  • Added functionality to close the Connect dialog with ESC key
• Version 1.0.1.82 - December 22, 2000
  • Added/Enhanced initial PostgreSQL support
  • Modified Alias box to include PostgreSQL DSNs
  • Added External calls to ODBC and BDE admin utilities
  • Fixed problem with TablesList when connecting to MSSQL 6.5
• Version 1.0.1.81 - December 5, 2000
  • Modified to work with MDAC 2.6 RTM
• Version 1.0.1.80 - October 23, 2000
  • Fixed problem when dropping column via MySQL Admin (urSQL Incident #0073)
  • Other various enhancements
• Version 1.0.1.79 - October 4, 2000
  • Fixed MySQL Connection Problem (urSQL Incident #0078)
• Version 1.0.1.78 - September 28, 2000
  • Added MSSQL 7.x connection debug options
  • Added --adop command-line option (prompts for ADO Connection)
  • Added --vserver command-line option (verify server name)
• Version 1.0.1.77 - September 13, 2000
  • Modified help file to launch browser for web files.
  • Enhanced urCommands.
  • Added Register Button and Links
• Version 1.0.1.76 - September 12, 2000 **Development/Beta Build**
  • Added support for processing multiple SQL statements (urSQL Incident #0050)
  • Enhanced urCommands
• Version 1.0.1.75 - August 27, 2000 **Development/Beta Build**
  • Enhanced initial (limited) support for Oracle 8i.
  • Enhanced initial (limited) support for MS Access.
  • Added basic support for unknown ODBC-compliant Datbases.
  • Tested Interbase.
  • Exe name changed to ursql.exe from urbsql.exe
• Version 1.0.1.74 - August 22, 2000 **Development/Beta Build**
  • Added initial (limited) support for Oracle 8i.
  • Added initial (limited) support for MS Access.
  • Fixed intermittent problem that caused an error when selecting Auto-Run
• Version 1.0.1.73 - August 14, 2000
  • Added feature to allow the manual saving/restoring of grid layouts (urSQL Incident #0070)
  • Fixed problem that caused key-press to activate last memo intermittently
• Version 1.0.1.72 - August 4, 2000
  • Added self-commenting to auto-generated queries
  • Added hint to indicate data-type for Columns/Fields list
• Version 1.0.1.71 - August 3, 2000
  • Fixed problem with MySQL Admin Drop Column feature
  • Enhanced HTML Export capabilities
  • Enhanced auto-generated query format
• Version 1.0.1.70 - July 20, 2000
  • Fixed refresh problem with MySQL Admin Tree (urSQL Incident #0060)
  • Changed Edit/Alter to set focus in grid
  • Fixed problem with DB Toolbar and Live Results (urSQL Incident #0064)
• Version 1.0.1.69 - July 12, 2000
  • Added Ability to Selectively Display Databases in MySQL Admin Tree (urSQL Incident #0068)
• Version 1.0.1.68 - May 4, 2000
  • Enhanced MSSQL 7.x Login Routines
  • Fixed minor problem with MySQL Admin Tree
  • Fixed problem when logging in after failed login
  • Other minor enhancements
• Version 1.0.1.67
  • Private Build - Not Released
• Version 1.0.1.66
  • Development Build - Not Released
• Version 1.0.1.65
  • Development Build - Not Released
• Version 1.0.1.64 - April 27, 2000
  • Added functionality to view BLOB fields
  • Added functionality to view MEMO fields
  • Fixed problem with Database Disconnect
  • Changed version number to 1.0.xx.xx
  • Fixed memory leak
  • Various other changes, enhancements, and fixes (urSQL Incident #0059)
• Version 0.19.3.42 - December 31, 1999
  • Added functionality to Export Result Sets
  • Enhanced MSSQL 7.x Functionality
• Version 0.19.2.41
  • Development Build - Not Released
• Version 0.19.2.40
  • Development Build - Not Released
• Version 0.19.2.39 - November 10, 1999
  • Various Enhancements and Minor Fixes.
• Version 0.19.2.38+ - November 4, 1999
  • Added functionality to visually Drop Databases
  • Fixed problem with Add New Table
  • Added Submit Incident tab for gathering debug info
  • Upgraded HTML and Communications DLLs/OCXs
• Version 0.19.2.37
  • Development Build - Not Released
• Version 0.19.2.36 - October 15, 1999
  • Added functionality to visually create tables (urSQL Incident #0047)
  • Fixed bug that prevented the editing of a Primary Key column.
• Version 0.19.2.35 - October 13, 1999
  • Added functionality to visually edit columns and tables.
  • Added HTML viewer for help.
  • Added documentation.
  • Fixed code templates to be saved and restored from session to session (urSQL Incident #0028)
• Version 0.19.2.29 - August 4, 1999
  • Added ability to open urSQL when associated with an extension in Windows explorer.
  • Various other enhancements and fixes.
• Version 0.19.1.19 - Circa May 1999
  • Fixed problem with Auto Run feature.
  • Added warning when exiting if query has not been saved (urSQL Incident #0022)
  • Added extensions to Save Dialog.
  • Various other enhancements and fixes.
• Pre-Version 0.19.1.19 - June 1998
  • Not documented.

© 1998-2006 Urban Research. All rights reserved.