MS Sql Server from Unix

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

Hi , i was working in a little perl script to get some info from a MS SQL 2000 Server, my script was in a W2k machine, but now i have to move it to a Unix machine, anyway i was reading about how to connect to a MS SQL Server from a Unix machine, i did read about some programs that can help ( unixodbc for example ) but my question is, what have you used for it, which program ( driver manager and driver ) could you recomend me to use, something important here is that i can't install anything in the SQL SERVER, and i can install what i need in the unix server. Thank you

Comment on MS Sql Server from Unix

Replies are listed 'Best First'.
Re: MS Sql Server from Unix by Beatnik (Parson) on May 26, 2002 at 12:29 UTC
In the April issue of Linux Journal (the one with catchy header "Quicktime on Linux" and with the interview with Robert Love), Andrew Trice discusses how he used FreeTDS thru DBD::Sybase to connect to MS SQL 2000. Andrew used the following freetds.conf `[fillinhostname] host = fillinhostname port = someportnumber tds version = 7.0` [download] IIRC someone used a reference to that same LJ article but unfortunatly I can't find the node_id... Greetz Beatnik ... Quidquid perl dictum sit, altum viditur.	[reply] [d/l]
Re: MS Sql Server from Unix by JayBonci (Curate) on May 26, 2002 at 20:16 UTC
It may water down your functionality a bit, but you could use DBD::ODBC from CPAN. There is also a DBIx::MSSQLReporter that is specifically for connection to an MS SQL Server. The problem is a little hairy, but I think one of those two modules should provide what you are looking for. Good luck. --jb	[reply]
Re: MS Sql Server from Unix by Anonymous Monk on May 26, 2002 at 20:14 UTC
You can also get JDBC drivers from MS. Free download from their website.... Just got them myself, but have not had the time to take a look at them. HTH .mark	[reply]