Perl and MS SQL Server 1

[JaySang]

I need some beginner help on using perl to connect to an SQL Server 2000.

Versions
Perl v5.8.0
DBI v1.45
MS Sql Server 2000

I just installed the DBI but when i try and connect using use DBI;
use DBD::ODBC;

I get an error "Can't locate DBD/ODBC.pm in @INC"

Which leads me to believe that DBD::ODBC is not installed but when I try and download activestate DBD-ODBC i get and error. I tracked the error to incompable versions of perl. But i cannot find a DBD::ODBC for perl 5.8

Any suggestions ? Any problems with my assumptions above ?

 

[raklet]

Install DBD-ODBC through ppm instead of cpan. It will download and install the proper package for your version of perl.

From a prompt.

c:\>ppm install DBD-ODBC

 

[JaySang]

I don't have internet access on the computer with perl on it. Its on a private closed network.

 

[raklet]

Download and install the files on a computer that has internet access. Copy the entire C:\Perl directory to a disk and move it to the same location on the computer that needs to have it installed.

Raklet