Run OLE DB SQL query or command from the command line or from a batch file.
http://tekkies.co.uk/go/runsqloledb
OLE DB Command Line SQL Query Execution v1.4.4269.35740
(C) 2011 Andrew Joiner http://tekkies.co.uk/go/runsqloledb
This software is provided "as is". Use at your own risk.
Usage:
RunSQLOLEDB "[connection string]" "[query]"
e.g.
RunSQLOLEDB "Provider=SQLOLEDB;Data Source=(local);..." "SELECT GetDate()"
RunSQLOLEDB @ConnectionString.txt @Query.sql
I use this to access Sybase Advantage databases, but I guess you can use it for mySQL, SqlServer, Oracle...
