Accesing "MS SQL Server"

lbarbago has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I want to access to "Microsoft SQL Server" through a perl script to make a query. I have read some tips here about how to do it but as far I can see, they all involve having DBI module (which I have) and DBD::ODBC (which I don´t). The main problem is I'm not a root user, so I guess I can´t set it up. Any ideas how to go on?

Comment on Accesing "MS SQL Server"

Replies are listed 'Best First'.
Re: Accesing "MS SQL Server" by marto (Cardinal) on May 26, 2010 at 10:30 UTC
Read Accessing Microsoft SQL Server from Linux using DBD::Sybase (including the replies) from the tutorials section, as well as Yes, even you can use CPAN. Update: Hang on, which operating system are you using?	[reply]
Re^2: Accesing "MS SQL Server" by rgcosma (Beadle) on May 26, 2010 at 22:38 UTC
If you will use FreeTDS, do remember that it doesn't support placeholders, i.e. $dbh->prepare("select * from table where something=?","parameter value")	[reply]