Well, without knowing the exact error, this is all guessing, but here goes:

Does the 15th entry in the array get translated into a SQL-like piece of code? For example, if the 15th entry was something like: SELECT agreement.Field2 FRM agreement then your actual command would end up looking like this: SELECT agreement.Field2 FROM agreement WHERE (((agreement.Field1)=SELECT agreement.Field2 FRM agreement)) and it would/should blow up on the 'FRM'. Admittedly, this is a unlikely example, but anything in your array entry that looks like SQL might be parsed by Access as SQL, and therefore cause a SQL syntax error. Or worse, actually be executed (imagine putting a DROP TABLE agreement in the URL).

Or - I don't use Win32::ODBC (I prefer DBI), but "Programming the Perl DBI" mentions that Win32::ODBC doesn't use statement handles, but rather uses the database handle to process the SQL command. It also goes on to state that database handles can be cloned (although it doesn't explain how that happens). In your example you create a database handle via $qry = new Win32::ODBC('support_agreement_DSN');. You then use that database handle each time you do a new query. If Win32::ODBC is actually 'cloning' that database handle each time you create a new SQL statement, you could be running out of database handles.


Those are my thoughts on the subject.

In reply to Re: ODBC by BlueBlazerRegular
in thread ODBC by Anonymous Monk

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.