Attck of teh AzN Cow flu! (cowbert) wrote in unixadmin,
Attck of teh AzN Cow flu!

iodbc < unixODBC

Anybody wanna tell me why libiodbc doesn't ship with an isql-like tool (sorry, but iodbctest is just lame)?

Plus unixODBC also has DataManager (which isn't as cool as the MSSQL Enterprise viewer, but for quick-and-dirty schema lookups it's great). But the big thing about unixODBC's isql is that I can run a quick query by basically doing: isql DSN UID PWD < "SELECT col FROM tbl WHERE expr". I can then redirect it to a file or pipe it to mail or lpr (just like the in the 80s. :) Not to mention if I'm in interactive mode, it actually has query editing and query history functionality (probably using readline(3) or something)!

(I would use unixODBC, except for the fact that RedHate ships with iodbc and not with unixODBC :)
  • Post a new comment


    default userpic

    Your IP address will be recorded