connect to sqlserver directly from Unix Prompt

[ann124]

Hi,
How can I connect directly to sqlserver from a Unix Prompt?
I am using DataDirect in the ODBC connectivity. Is there any way whether I can connect to SQLServer from the prompt,just a select stmt will do.

For eg: if I use select * from table|sqlplus -s usernmae/password@hostname

Let me know.
Any ideas or solutions are welcome

 

[ingresman]

If you have the tool to do it yes and the ODBC driver supports it, Are you asking for an actual product name??. Do merant not supply some kind of test tool or do you fancy writing one ?. I would ask this in the sqlserver forum, not the mysql one.