Google Answers Logo
View Question
 
Q: Perl Queries MS SQL ( Answered 5 out of 5 stars,   1 Comment )
Question  
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?
Answer  
Subject: Re: Perl Queries MS SQL
Answered By: hailstorm-ga on 21 May 2003 22:10 PDT
Rated:5 out of 5 stars
 
keshar,

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
cons:  http://www.algonet.se/~sommar/mssql/alternatives.html

Sites Cited:
  CPAN
  http://www.cpan.org

  DBI Homepage
  http://dbi.perl.org/

  MSSQL:Dlib and MSSQL:Sqllib
  http://www.algonet.se/~sommar/mssql/

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

Comments  
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.

http://www.respree.com/cgi-bin/pdbwrap.pl?+Keywords=monet

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 answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


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