Thanks! You're right, this is a much different version. When I tried to use it, I got an error that it could not make the connection. I think it is so old it requires an older ODBC.DLL, and I'm afraid that will be too different to be useful.

So I studied the FetchRow code in the two versions of Win32::ODBC, and got nowhere! They both call ODBCFetch (in the DLL). The new version has a second argument, the one that is supposed to invoke SQLExtendedFetch. But removing this argument entirely *still* called SQLExtendedFetch.

I think it is the ODBC.DLL that determines which Fetch to use, based on whether there are arguments, so I just don't see why SQLFetch is NOT being used when there are no arguments.

I've tried to force ODBC.DLL to use SQLFetch, which should be the normal case. I've studied all the connection options and tried setting various cursors to no avail.

This is a shame, because it means the CodeBase driver cannot be used with Perl. It also seems to mean that all apps that use of Win32::ODBC are using extended fetch when they could be using the simpler fetch.

Many thanks for your help. I would say Win32::ODBC is just not a serious product.

Stephen

In reply to Re^2: Win32::ODBC FetchRow by Stephen Toney
in thread Win32::ODBC FetchRow by Stephen Toney

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.