Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

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

by enky123 (Initiate)
on Feb 28, 2014 at 08:21 UTC ( #1076490=note: print w/ replies, xml ) Need Help??


in reply to 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
Re^2: Accessing Microsoft SQL Server from Linux using DBD::Sybase
by Anonymous Monk on Feb 28, 2014 at 09:13 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.

        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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1076490]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2015-07-03 06:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (48 votes), past polls