Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

DBI connect is failing with Perl v5.16.3

by prashantktyagi (Scribe)
on Apr 23, 2013 at 08:47 UTC ( #1030077=perlquestion: print w/replies, xml ) Need Help??
prashantktyagi has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks,

I am getting below error while making connection to Proxy DB server. It was working fine before upgrade from Perl 5.6 to Perl 5.16 (Strawberry Perl ). Do anyone have any idea or how to trace the issue ?

error : DBI connect('hostname=<ip>;port=9002;dsn=DBI:ODBC:<dbname>','< +username>',...) failed: Cannot log in to DBI::ProxyServer: Unexpected + E OF from server at C:/Perl64/perl/site/lib/RPC/ line 79. at C:\EclipseOVII\oviisrc\lib\package\perl5\ line 53.
Here is DB test script..
removed code part as it was against my org policy

Replies are listed 'Best First'.
Re: DBI connect is failing with Perl v5.16.3
by marto (Bishop) on Apr 24, 2013 at 10:38 UTC

    What you don't mention is that you did a force install of this module, because a prerequisite (Net::Demon) isn't installed. After much talk in the CB to draw these facts (and others) from you, it transpires that you later did a force install of Net::Demon also, based upon a false understanding of the test results. If you're going force install modules and their prerequisites without bothering to find out if the failures are pertinent then you're going to continue to hit problems like this.

    I've repeatedly told you in the chatterbox, but once more in case you have problems understanding. When you want to install a module, check the open bugs, there may be some issues/patches you need to address/apply depending on your platform/perl version. If tests fail find out why they fail, perhaps there's something you need to do to make this module work within your environment. It's a waste of your time, and everyone else’s, for you to keep asking the same questions over and over while ignoring the answers. Please read and understand How do I post a question effectively?.

      Though I explained everything but it seems to me with arguments we can't solve any problems. I have read How do I post a question effectively? long back and no post is complete in first time...

      If i knew the problem at first place why would I have post it communities are here to contribute to society not for sarcasm.. I posted error message so if someone had faced the issue before , i don't have waste much time.

        You keep mentioning sarcasm, I was never sarcastic. Perhaps you're confused as to the meaning of the word.

        After much discussion it turned out that you were running Strawberry Perl, I stated that your post would benefit from knowing this, as others had suggested installing DBI and DBD::ODBC, which ship with Strawberry as standard. You insisted (twice) that you had mentioned running Strawberry in the post, even though you hadn't. Later you updated the post to include this information. The post does not state at any point that you forced module installations, specifically the ones required which throw the only error you show. Your "Though I explained everything" quote is baseless. You've not given anyone enough information to help.

        "i don't have waste much time."

        You've wasted plenty of time today ignoring repeat advice on how to debug this issue.

Re: DBI connect is failing with Perl v5.16.3
by jakeease (Friar) on Apr 24, 2013 at 10:35 UTC

    You are setting the server's hostname to '<IP>'. Is that what you intended?

    sub dbiConnect { my $server = '<IP>'; my $port = reservedDBPort($server);
      Yes, intended..
Re: DBI connect is failing with Perl v5.16.3
by prashantktyagi (Scribe) on Apr 25, 2013 at 05:56 UTC
    removed as it was against my org policy

      "successfully installed DBI"

      You already had DBI and the associated modules installed. We established this yesterday after much tortuous discussion. You've turned on tracing which has given you the same error and the same line number to look at as yesterday. Despite repeated advice you don't seem to have looked at the code Perl tells you is failing.

        you don't seem to have looked at the code Perl tells you is failing.
        Can you tell me which code I should check ?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1030077]
Approved by bingos
Front-paged by Xiong
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (6)
As of 2018-03-21 01:23 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (263 votes). Check out past polls.