Re: Accessing Microsoft SQL Server from Linux using DBD::Sybase

Hi .... U have mentioned connecting to MSSQL by using FreeTDS as /usr/local/freetds/bin/tsql -S sql1 -U sqluser. I need to pass more arguments to it, i.e. Query & and redirect the same to an output file in the same commandline. so can this be possible ? /usr/local/freetds/bin/tsql -S sql1 -U sqluser -I Query -o Outputfile. Please Help.

Comment on Re: Accessing Microsoft SQL Server from Linux using DBD::Sybase

Replies are listed 'Best First'.
Re^2: Accessing Microsoft SQL Server from Linux using DBD::Sybase by Anonymous Monk on Feb 28, 2014 at 09:13 UTC
Hi .... U have mentioned ... 9 years ago Hi, CleverFox hasn't visited in 9 years, and wasn't using tsql Welcome, see The Perl Monks Guide to the Monastery and PerlMonks FAQ See also system and pass however many arguments you want	[reply]
Re^3: Accessing Microsoft SQL Server from Linux using DBD::Sybase by enky123 (Initiate) on Feb 28, 2014 at 09:59 UTC
Hi, I have tried passing arguments as a Query & an Output file. But that's not working. Please take a look below. see below syntax, (This works !!!!!) /usr/local/freetds/bin/tsql -S sql1 -U sqluser -P sqlpassword. But the below command doesnt work. /usr/local/freetds/bin/tsql -S sql1 -U sqluser -P sqlpassword -I Query -o Outputfile.	[reply]
Re^4: Accessing Microsoft SQL Server from Linux using DBD::Sybase by Anonymous Monk on Feb 28, 2014 at 10:06 UTC
Hi, I have tried passing arguments as a Query & an Output file. But that's not working. um, ok, but that is not perl code ... https://wiki.apache.org/tajo/tsql doesn't show any -I or -o options so check the documentation for whatever tsql program you have	[reply]