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

HI, I Changed the code still its giving error. 
use DBI;
           my $user = "user";
        my $passwd = "user";
    $dbh = DBI->connect("dbi:Sybase:host=10.89.40.35;port=2640;databas
+e=master",$user, $passwd);

[download]

The error are ------ install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC contains : C:/Perl/site/lib C:/Perl/lib .) at (eval 3) line 3. Perhaps the DBD::Sybase perl module hasn't been fully installed, or perhaps the capitalisation of 'Sybase' isn't right. Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL ite, Sponge, mysql. at sybaseconnect.pl line 6.

I am trying to connect a remote server(Sybase). Sybase is not installed locally in my machine. All the drivers is installed properly. i am using active perl 5.14. My local machine is in windows and the sybase is installed in Sun solaris machine. Please help.

Thanks in advance.

Replies are listed 'Best First'.
Re: unable to connect sybase DB in windows
by MidLifeXis (Monsignor) on Apr 23, 2013 at 12:49 UTC

    Note: This node was written prior to an undocumented update by the OP.

    In addition to what AM has asked, 

    $dbh = DBI->connect("dbi:Sybase:host=10.89.40.35;port=2640",database=m
+aster,$user, $passwd);

    [download]
    does not parse, as the closing quotes are in the wrong location. I believe that you want the line to look like: 
    $dbh = DBI->connect("dbi:Sybase:host=10.89.40.35;port=2640;database=ma
+ster",$user, $passwd);

    [download]

    --MidLifeXis

[reply]
[d/l]
[select]
Re: unable to connect sybase DB in windows
by Anonymous Monk on Apr 23, 2013 at 07:39 UTC
    And the error message is?
[reply]
Re: unable to connect sybase DB in windows
by MidLifeXis (Monsignor) on Apr 24, 2013 at 12:32 UTC

    Note: It is usually considered good form to notate what you have updated in your original post, or to post updates as a response.

    Have you installed DBD::Sybase? Perhaps you need to do a cpan DBD::Sybase. If you don't have MinGW installed, you may also need to do a ppm install MinGW.

    --MidLifeXis

[reply]
[d/l]
[select]
      Hi, Both DBD::Sybase & MinGW is installed.

      C:\Downloads\DBD-Sybase-1.1 4>ppm install DBD-Sybase.ppd

      Unpacking DBD-Sybase-1.14...done

      Generating HTML for DBD-Sybase-1.14...done

      Updating files in site area...done

      9 files installed

      Still same error is coming.

      The error are ------ install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC contains : C:/Perl/site/lib C:/Perl/lib .) at (eval 3) line 3. Perhaps the DBD::Sybase perl module hasn't been fully installed, or perhaps the capitalisation of 'Sybase' isn't right. Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL ite, Sponge, mysql. at sybaseconnect.pl line 6.

[reply]

        • Try perldoc -l DBD::Sybase.
        • Are there other errors? Perhaps something about not being able to load a DLL file or the like?

        --MidLifeXis

[reply]
[d/l]
Re: unable to connect sybase DB in windows
by Anonymous Monk on Apr 24, 2013 at 13:46 UTC
[reply]

Back to Seekers of Perl Wisdom