Hello!
I have such a problem. I am not sure that it is related to perl, but as long as I am using it, I decided to post a question here.
I'm using an ODBC for connection the DB with Perl. Here's such a simple example:
my $result;
$db = new Win32::ODBC("DSN=DSNName;UID=$login;PWD=$pass") or die;
print "Connected to DB! \n";
$db->Sql    ("Select name from person");
while ($db->FetchRow) {
    $result = $db->Data();
    print "Result is - $result";
}

[download]
The problem is that when I am using it for a simple queries, that doesn't take much time - it's fine. It connects to the DB, executes the query and returns the result data.
But if it is a big query, that needs some time to be executed (at least several minutes) - than the script returns no result to me. It looks like it even doesn't get inside the "while". How can it be?
Is it possible, that there's some time limit? Like a session limit or whatever?
Did anyone happen to face with problems like this? I would appreciate any help.

Thanks a lot.
Waiting for your replies.

In reply to Perl + ODBC + long time queries by Kirill

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.