Done database access from command line


Staff member
May 14, 2008
database access from command line

A couple of years ago I came across a suite of command line utilities by Diomidis D. Spinellis at[title] that included a tool called "odbc.exe" that I use to run "SQL SELECT" queries from the command line. It has the following usage notes:

usage: odbc [-v] [-R RS] [-F FS] [-h] [-n null] DRVC stmt
RS Record separator (default is newline)
FS Field separator (default is tab)
null Null value string (default is empty)
DRVC ODBC driver connection string
-h Print column headings on first line
-v Print the program's version and copyright string
stmt A valid SELECT statement

DRVC can either specify a registered DSN, as in:
or directly a driver, as in:
"Driver={Microsoft Access Driver (*.mdb)};DBQ=myfile.mdb"

I am wondering if this functionality would be a useful addition to a future version of TCC.

Please comment ...


John McMahon on December 26, 2011

Similar threads