[DCPM] sql server

[Aaron Trevena]

On 9/26/05, Simon Waters <simon at technocool.net> wrote:
> Steve Marvell wrote:
> > Has anyone got a Unix box talking to SQl Server using Perl?
>
> No all our MS SQL to Unix talk is done via http so as to tunnel through
> firewalls.
>
> But opinion here is "how hard can it be?".
>
> I've done Unix ODBC before (not Perl), and as long as there is a
> compatible ODBC driver all you should need is "use DBI ;"
>
> Apparently DBD::ODBC includes a compatible ODBC driver.
>
> The usual caveats about ODBC/MS SQL apply, it looks pretty but think
> twice, or test hard, before you bet the business on it.

When I did this I used DBI::Proxy.. handy and securable, should also
play nice with ssh port forwarding should you want the connection
encrypted and on different ports.

Other than that I think you have a choice of a unix ODBC and DBD::ODBC
or doing DBD::Sybase and FreeTDS

some useful urls :

http://search.cpan.org/~jurl/DBD-ODBC-1.13/ODBC.pm
http://sourceforge.net/projects/sqsh (sql server shell for *nix)
http://www.susesecurity.com/sql-dbi_howto.shtml
http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux
http://www.doc.ic.ac.uk/csg/faqs/sql-server.html

this post acts more of a note to self than direct help sorry :)

A.