Google Answers Logo
View Question
Q: Perl Queries MS SQL ( Answered 5 out of 5 stars,   1 Comment )
Subject: Perl Queries MS SQL
Category: Computers > Internet
Asked by: keshar-ga
List Price: $2.00
Posted: 16 May 2003 12:11 PDT
Expires: 15 Jun 2003 12:11 PDT
Question ID: 204731
Can a perl installation on a linux/unix machine query a MS SQL Server
database?  What does Perl and or the linux/unix system need if that
ability isn't built-in?
Subject: Re: Perl Queries MS SQL
Answered By: hailstorm-ga on 21 May 2003 22:10 PDT
Rated:5 out of 5 stars

Thank you for your question.  By far the most recommended method of
accessing a database via Perl is through the DBI module.  Using the
DBD::ODBC connectivity, you can not only make queries to an MS SQL
Server, your code also becomes almost completely portable, meaning
that even if you move your database to another OS or another platform,
your Perl code will require little to no modification to make the
migration.  For more information, check the documentation offered on
CPAN and the DBI Homepage.

For other options available to you besides the DBI module, this site
discusses many of the other alternatives, along with their pros and

Sites Cited:

  DBI Homepage

  MSSQL:Dlib and MSSQL:Sqllib

Google search strategy:
  DBI Perl "SQL Server"
keshar-ga rated this answer:5 out of 5 stars

Subject: Re: Perl Queries MS SQL
From: respree-ga on 16 May 2003 12:31 PDT
The short answer to your question is "Yes."

Here is an example of a Perl script (notice the .pl extension)
querying a MYSQL database running on a Linux (Debian) machine.  I'm
not a programmer, so I can't really answer specifics, but I know it
can be done.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy