in reply to DBI for SQL Server issue - can't locate object method "set_sql" via package "Class::DBI::MSSQL

I'm going to take a chance here, and ask;
Have you installed the MSSQL adapter for DBI: Class::DBI::MSSQL?

I haven't had the opportunity to work on a winboxen to deal with Perl, and MSSQL. But the error you submitted looks suspiciously like DBI can't find the MSSQL Class.

--Chris

#!/usr/bin/perl -Tw
use Perl::Always or die;
my $perl_version = (5.12.5);
print $perl_version;
  • Comment on Re: DBI for SQL Server issue - can't locate object method "set_sql" via package "Class::DBI::MSSQL

Replies are listed 'Best First'.
Re^2: DBI for SQL Server issue - can't locate object method "set_sql" via package "Class::DBI::MSSQL
by newbieperlperson (Acolyte) on Nov 25, 2013 at 20:58 UTC

    Hi Chris,

    I do have it installed, I copied the CPAN tar and extracted it to lib\class\dbi

[reply]
      Hmm...
      You didn't take the standard "install" approach? 
      tar xvz Module-Name-xxx.tar.gz
cd Module-Name-xxx
perl ./Makefile.PL
make
make test
make install PREFIX=/my/perl_directory

      [download]
      I'm pertty sure that the Module will not be properly registered, otherwise.
      While you could attempt
      use lib ('/path/to/perl/modules');
      I'm not sure why you wouldn't simply choose a "standard" install for this module.

      Anyway. Just my thoughts on it.

      --Chris

      #!/usr/bin/perl -Tw
use Perl::Always or die;
my $perl_version = (5.12.5);
print $perl_version;
[reply]
[d/l]
        Hi Chris,

        I am so fresh off the boat with Perl, I did not attempt to install it the way you demonstrated, I just tried and got an error.

        11/25/2013 01:12 PM <DIR> . 11/25/2013 01:12 PM <DIR> .. 11/10/2006 08:01 PM 326 Changes 11/25/2013 01:12 PM <DIR> lib 11/07/2006 08:10 PM 20,593 LICENSE 11/25/2013 01:12 PM 24,424 Makefile 11/06/2006 02:38 PM 584 Makefile.PL 11/10/2006 08:02 PM 210 MANIFEST 11/10/2006 08:02 PM 477 META.yml 08/14/2006 10:03 AM 176 README 11/25/2013 01:12 PM <DIR> t

        C:\aj\Class-DBI-MSSQL-0.122>perl ./Makefile.PL Set up gcc environment - gcc (gcc-4.6.3 release with patches build 20121012 by perlmingw.sf.net) 4.6.3 WARNING: LICENSE is not a known parameter. Warning: prerequisite Class::DBI 0.95 not found. 'INSTALL_BASE' is not a known MakeMaker parameter name. 'LICENSE' is not a known MakeMaker parameter name. Writing Makefile for Class::DBI::MSSQL

[reply]
        Hi Chris,

        Than you for your help.

        It looks like I need a number of other dependencies, such as Class-DBI-0.95.

        Is there a quicker way to install all of these?

        AJ
[reply]

In Section Seekers of Perl Wisdom