Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

Done database access from command line

rconn

Administrator
May
13,076
197
Staff member
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

d671c2e8d5ef82b6ace25482169c374a
John McMahon on December 26, 2011
 

Similar threads

Back
Top