How to connect remote MS sql server from linux?

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

From FAQ,I know I have to install dbi and DBD::ODBC and ODBC driver. But I can't find freeware about ODBC driver.I just find some commerical ODBC driver. Can u give some clues to do that ?

thanks!

Comment on How to connect remote MS sql server from linux?

Replies are listed 'Best First'.
Re: How to connect remote MS sql server from linux? by gellyfish (Monsignor) on Mar 31, 2005 at 12:56 UTC
You will want to look at FreeTDS and UnixODBC alongside DBD::ODBC - I have found this to work well. /J\	[reply]
Re^2: How to connect remote MS sql server from linux? by iwanthome (Beadle) on Mar 31, 2005 at 14:25 UTC
thanks, I will try.	[reply]
Re: How to connect remote MS sql server from linux? by bpphillips (Friar) on Mar 31, 2005 at 14:52 UTC
Thank you Super Search: Accessing Microsoft SQL Server from Linux using DBD::Sybase. These instructions have worked for me in the past.	[reply]
Re^2: How to connect remote MS sql server from linux? by iwanthome (Beadle) on Apr 01, 2005 at 00:53 UTC
thanks.Next time I will use Super Search before I ask question.	[reply]
Re: How to connect remote MS sql server from linux? by rbi (Monk) on Mar 31, 2005 at 16:38 UTC
I'm using UniverSQL (http://www.sidespace.com) to access a MS SQL server from Linux. It has its own DBD module and a DBI-independent client. Actually, it comes with sample clients in Perl, PHP, Phyton, Java. It is however a commercial product. Single connection license is about 50 dollars. But maybe its an option for you.	[reply]
Re^2: How to connect remote MS sql server from linux? by iwanthome (Beadle) on Apr 01, 2005 at 00:56 UTC
thanks. I just do some test. So I will not use commercial product.	[reply]