[sllug-members]: Microsoft SQL Server

[Jackman]

I rather like the idea of using Perl or unixODBC to handle my SQL
access needs, but I am a little confused on one point.  Both the Perl
DBI Interace and the unixODBC suite reference a DB Driver that is
needed before they can do anything.  I am still not sure how to go
about it with the Perl interface, but ODBC tells me that the MS driver
is commercial and that i have to go through a company to go about
getting it.  From a few places I get the driver resides on the server
that I wish to use.  Is the driver something that i need to worry
about?  I am mostly focussing on Perl at this point with DBI if it
changes the way that I get help.  Thanks again.

Andrew Jackman.
W7MEZ.

On Tue, Apr 1, 2008 at 8:20 PM, Doran L. Barton <fozz at xmission.com> wrote:
> Not long ago, Jackman proclaimed...
>
> > Where I work, everything revolves around a row of very large servers
>  > with MS Windows NT running Microsoft SQL Server.  To connect to this
>  > server, I use primarily Microsoft SQL Query Analyzer and Microsoft
>  > Enterprise Manager.  My work is generally very tedious, mostly because
>  > MS software doesn't script very well.  I can bring my laptop into
>  > work, however, or install cygwin and work from those machines if I so
>  > desired.  Scripting and collecting data would be so much easier on a
>  > linux box.  Still, I know that MySQL is the SQL database preference on
>  > Linux systems and so I am having a difficult time finding anything
>  > that advertises itself being compatible with Microsoft SQL Server.
>  > Does it even matter?  Thank you for your help and I look forward to
>  > your input.
>
>  It should be fairly straight forward to connect to a M$-SQL server from
>  Perl (using the DBI module) or Java (using JDBC and/or Hibernate). The
>  UnixODBC folks < http://www.unixodbc.org/ > can probably provide some more
>  information about command-line utilities for more generic interaction, but
>  if you're looking for the ability to automate/script queries and other
>  database operations, I would highly recommend Perl+DBI.
>
>  --
>  Doran L. Barton <fozz at xmission.com> - Linux, Perl, Web, good fun, and more!
>   "Auto Repair Service. Free Pick-up and delivery.  Try us once, you'll
>   never go anywhere again."
>     -- Classified ad in newspaper
>
> ______________________________________________________________________
>  See http://www.sllug.org/ for latest SLLUG news, information, links.
>  Join SLLUG and other UT LUG members on irc.FreeNode.net channel #Utah
>  sllug-members at sllug.org
>  http://www.sllug.org/cgi-bin/mailman/listinfo/sllug-members
>
>