Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: PERL and MS-SQL Server 2000

by VSarkiss (Monsignor)
on Apr 17, 2006 at 14:55 UTC ( #543832=note: print w/ replies, xml ) Need Help??


in reply to PERL and MS-SQL Server 2000

To access SQL Server from Perl on windows, you have two clear choices and some unclear ones. Using DBD::Sybase is one of the unclear ones.

Your two simple choices are DBD::ODBC and DBD::ADO. Both of those work very well with SQL Server if you're on a Windows variant. Generally people fall back on using the Sybase driver (with freetds) when they have to connect to SQL Server from a Linux, Unix, or other non-Windows machine.

A couple of notes in general: Installing some Perl modules requires a compiler; DBD::Sybase is one of them. A very good workaround to having a compiler, if you're using ActiveState Perl, is to use ppm, the Perl Package Manager that comes with the ActiveState installation. You may have to dig around for a particular PPM package; Google is your friend here.

Even for packages that don't require compilation, it's often better to use an installer like ppm or the CPAN.pm module. That way you'll be sure everything is where it needs to be, that prerequisites are available, and so on.

Second general note: you don't need to explicitly call out the DBD package you want (in general). You can just do:

use DBI;
and the DBI.pm module will take care of the rest.

HTH


Comment on Re: PERL and MS-SQL Server 2000
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://543832]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2014-10-23 02:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (123 votes), past polls