OleDBCmd / News: Recent posts

This release incorporates a Visual Studio 2005 version of the source code and replaces a hard coded reference to the assembly name by using reflection instead. The binary versions are specifically set to the x86 32-bit environment to ensure the correct libraries are used.

Added XML format options to create much more useful XML and added SHOW LINKEDTABLES option so you can update linked tables when you move databases to a new location.

You can now use IF EXISTS on DROP TABLE and DROP VIEW. Also, you can use SHOW TABLES, SHOW VIEWS and SHOW PROCEDURES with extendedSQL mode to view table names or view/procedure definitions.

Version 1.5 includes enhancements to the extendedSQL commands and accumulated bug fixes.
Enjoy!
Blessings,
Ian Hogan.

Hi,
New binary and source releases are available for OleDbCmd. This adds further ADOX powered features. You can now set table properties and also create, alter and drop linked tables.
Enjoy!
Blessings,
Ian Hogan.

This release incorporates support for extended SQL in CREATE/ALTER/DROP VIEW/PROCEDURE statements for MS Access databases. It also supports extracting binary data as files, and using ODBC connections.

Blessings,
Ian Hogan.

Version 1.2 binary and source releases are now available for download. The source release is best built in SharpDevelop 2.1 as this allows for multi-platform support - ie .NET 1.1 and .NET 2.0. See http://sourceforge.net/projects/sharpdevelop/ for details.

Version 1.1 fixes minor bugs reported through the tracker - namely removal of trailing spaces, and changing /help to only output usage notes not the license details.

The enhanced version of OleDbCmd allows multi-line SQL commands, creating of a database embedded comments, CSV and quiet output modes, SQL command on command line, extended help, version and license details.

See the CVS or source distribution for sample usage.

Installation is simple - just put the files in a suitable folder and run OleDbCmd from there. Add the folder to your PATH environment variable if you like.

Still fighting with the SourceForge CVS... version 1 is done, just needs an upload.