Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I could not install Perl properly on windows server. The installation went through Ok but when I try to run my script it fails with missing DBD/ODBC which is required for ODBC connection. I tried to uninstall and reinstall but it did not help. MyReplica...install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .) at (eval 10) line 3. Perhaps the DBD::ODBC perl module hasn't been fully installed, or perhaps the capitalisation of 'ODBC' isn't right. Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.

Replies are listed 'Best First'.
Re: perl Install
by syphilis (Archbishop) on Sep 21, 2007 at 14:40 UTC
    Have you installed ActivePerl ?
    If so, I think you then need to install DBD::ODBC
    C:\>ppm install DBD-ODBC Downloading ActiveState Package Repository packlist...done Updating ActiveState Package Repository database...done Downloading trouchelle.com packlist...done Updating trouchelle.com database...done Downloading DBD-ODBC-1.13...done Unpacking DBD-ODBC-1.13...done Generating HTML for DBD-ODBC-1.13...done Updating files in site area...done 8 files installed
    Cheers,
    Rob
Re: perl Install
by mr_mischief (Monsignor) on Sep 21, 2007 at 14:54 UTC
    As others have pointed out, DBD::ODBC may not come with your copy of perl. I checked my Strawberry Perl and CygPerl installations. Neither came with this particular module. You'll have to install the module using PPM or CPAN.
      Thanks so much. I installed from the Active Perl site. I will try the suggestions.
        I get the following error when I tried the install C:\Documents and Settings\cqchmgmt>ppm install DBD-ODBC Downloading ActiveState Package Repository packlist...failed 500 Can't connect t o ppm4.activestate.com:80 (connect: Unknown error) ppm install failed: Can't find any package that provide DBD-ODBC
Re: perl Install
by perlfan (Parson) on Sep 21, 2007 at 14:32 UTC
    How did you install Perl on ur windows? ActiveState, Cygwin,..? It sounds like you'll have to install the ODBC interface using AS's package manager or CPAN.