Sorry, I had read so many of the posters I was focusing on what you said about verifying that the record was there via access which threw me off (it would be helpful to know which version of SQL Server you are running also 7.0?)... If running the same query using ISQL on your host server has the same failure, then you can verify that it is not the DBI or ODBC interface. Other than that, I would also try to see if M$ has updated ODBC drivers, or if you have the latest ones installed on the Server. Before you run off to Java, I would run a simple query using VB and and see if you get the same results...if you do.. then you can really point the finger at the DB. I built a DB with 1.2Million records... (sheese.. it took 30 mins - 1GB in size) and ran the same query... and it returned the records just fine. (Access however - I don't have MS SQL Server at home.) Only stuff I could think of. Good luck. JamesNC

In reply to Re: Re: Re: DBD::ODBC won't read past a certain record by JamesNC
in thread DBD::ODBC won't read past a certain record by Groll

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.