[sllug-members]: Microsoft SQL Server

[Eric Huber]

Use freetds and DBD::Sybase.

Works great!

> 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
>>
>>
>>
> ______________________________________________________________________
> 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
>
>


-- 
Eric Huber - eric at hubernet.com
Moonlight Design, LLC
(801) 451-2912    CELL: (801) 557-5112