Done database access from command line

rconn

Administrator
Staff member
May 14, 2008
12,356
150
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
Thread starter Title Forum Replies Date
S Done Extended directory search database Suggestions 2
kb6ojs Declined Offline access to forums? Like newsgroups? Suggestions 6
Kachupp Please have FFIND / TPIPE access stream:names Suggestions 2
rconn Declined Improve access denied error message Suggestions 0
rconn Declined Allow TC/TCC direct access to WinSock and other networking Suggestions 0
Roedy Done multi-job access Suggestions 4
B Declined Direct/shortcut access to the File Search finctionality Suggestions 2
Joe Caverly Done Specify which LIBRARY to run command from Suggestions 2
vefatica File name completion at the beginning of the command line Suggestions 6
L Done Suggestion for TCC 'ver' command Suggestions 8
JohnQSmith Done Modified last command prompt duration Suggestions 5
C Feature Request: Gain some elements of the XXCOPY feature set in COPY or a new "Mass-Copy" command Suggestions 0
D Done SHORTCUT command should accept unexpanded environment variables. Suggestions 0
mfarah Unix-like clear screen keystroke command. Suggestions 0
C Powershell ISE tabbed within Take Command Suggestions 0
D Command Input Feature Request Suggestions 0
R Done Putting command output into an array Suggestions 2
R Done Execute command while at a breakpoint Suggestions 4
R Done Allow single stepping within a command group Suggestions 5
R Declined wish-list: add a command to copy a file to clipboard. Suggestions 17
A Declined Navigation in Take Command Suggestions 4
x13 SORTARRAY command Suggestions 1
R ffind /= and command line Suggestions 0
A Declined Enhance OPTION command functionality Suggestions 2
R Done Command History Window: select more than one line. Suggestions 0
R Declined History: show in which directory a command has been typed. Suggestions 6
N Declined GUI for select command Suggestions 0
Charles Dye Done TCEDIT: Command-line option to print files Suggestions 2
Charles Dye Declined Windows functions and command: Add syntax to specify HWND directly Suggestions 0
vefatica Declined @@key alias at beginning of partial command line Suggestions 10
R Save and load a command dialog set and name it Suggestions 3
Alpengreis Done Add "Slow copy" (/WAIT) parameter to SYNC command Suggestions 1
L Completing the UnQLite command's option set Suggestions 0
joltcoder Done Support an "up" command to go to parent directory and "up3" to go up 3 directories, etc. Suggestions 4
M Declined Command line support for Virustotal Suggestions 0
A Declined Take Command/Debugger as a Visual Studio 2017 add-in/extension Suggestions 4
Joe Caverly Done UnLIBRARY command Suggestions 9
jaejunks Done Option for case-sensitive string comparison in IF command (for CMD compatibility) Suggestions 1
rps Done Log entry command Suggestions 3
rps Done Command and directory history pop-up additions Suggestions 2
rps Command History window options Suggestions 0
rps Declined Command output spacing options Suggestions 0
rps Done Command History edit additions Suggestions 0
J Done Set font in Take Command tabs in a .btm Suggestions 1
rconn Add a parameter to dir command to handle zip files as folders Suggestions 1
rconn Command Line constructor custom DIALOGs for batch files Suggestions 0
rconn A Command-line comparison Suggestions 0
W Done Add colorize to tree command? Suggestions 0
S Done Eject removable USB drives command Suggestions 2
Alpengreis Declined Any chance for quick help with all command-options? Suggestions 3

Similar threads