I’ve released the source for SQL_CLI under the GPL. SQL_CLI is a simple program that allows you to run a set of SQL commands against a given DSN (or DSN-less connection string) using either OLE or ODBC.

It is written in C#, and the code should be easy enough for someone to understand.

It takes three arguments:

  • [ole|odbc] - The type of connection to make
  • [DSN] - The name of a DSN, or else a DSN-less connection string
  • [filename] - A SQL command file - essentially, a file with one SQL command per line

Hopefully some of you should find this useful - I use it for mass imports of data into all sorts of databases.

Source is here:
https://svn.lokkju.com/svn/SQL_CLI/trunk/