Hi!

First of all, let me thank you for your time and knowledge sharing, I'm kind of an ignorant in trems of perl modules

I have a 64bit ubuntu Server 12.04, with Perl version 14, subversion 2 (v5.14.2) built for x86_64-linux-gnu-thread-multi and CPAN exploration and modules installation (v2.10).

I'm trying to use a perl script accessing a Microsoft SQL Server and I'm having a really hard time upon the DBD::Sybase module

When I try to install DBD::Sybase CPAN tells me it's already installed

cpan[1]> install DBD::Sybase                                          
+                                                               
Reading '/root/.cpan/Metadata'
  Database was generated on Wed, 29 Apr 2015 14:53:21 GMT
DBD::Sybase is up to date (1.15).

[download]

I also find multiple Sybase.pm files on my filesystem, some of them are under Perl path

root@server:# find /* -name Sybase.pm
/home/usriten/download/DBD-Sybase-1.15/Sybase.pm
/root/.cpan/build/DBD-Sybase-1.15-TtUI0T/Sybase.pm
/root/.cpan/build/DBD-Sybase-1.15-kNqdf7/Sybase.pm
/root/.cpan/build/DBD-Sybase-1.15-rZgcTa/Sybase.pm
/usr/local/lib/perl/5.14.2/Sybase.pm
/usr/local/lib/perl/5.14.2/DBD/Sybase.pm
/usr/local/lib/perl/5.14.2/DBI/Sybase.pm

[download]

But when I try to run my script it returns an error on a line that calls 'if ($self->{handle} = DBI->connect('

# ./check_mssql_health --hostname <MSSQL_Server_IP> --username <SQL_Us
+er> --password <Pass> --mode connection-time
CRITICAL - cannot connect to <MSSQL_Server_IP>. install_driver(Sybase)
+ failed: Can't locate loadable object for module DBD::Sybase in @INC 
+(@INC contains: . /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/sha
+re/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /us
+r/share/perl/5.14 /usr/local/lib/site_perl) at (eval 10) line 3
Compilation failed in require at (eval 10) line 3.
Perhaps a module that DBD::Sybase requires hasn't been fully installed
 at ./check_mssql_health line 3192

[download]

I've already spent a lot of time scavenging posts but I did not find a solution or at least one I could understand and Implement.

Best regards, Sebastião

In reply to DBD::Sybase error by sebastiaopburnay

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.