Done database access from command line

rconn

Administrator
Staff member
May 14, 2008
10,785
97
#1
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:

06:53>odbc
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:
"DSN=registered_dsn_name;uid=myusername;pwd=mypassword"
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

John McMahon on December 26, 2011