Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: ODBC

by dws (Chancellor)
on Apr 30, 2002 at 23:28 UTC ( [id://163187]=note: print w/replies, xml ) Need Help??


in reply to ODBC

Unfortuantely, when the array has more than 14 entries, a perl.exe error window pops up.

Lacking info on what your data looks like, I can only provide a few hints:

  1. Rather than reusing the connection ($qry), create a new one inside of the loop, use it, and close it. If there's a problem with Win32::ODBC recycling data structures for queries, this should side step it.
  2. Beef up your error detection. Print $qry->Error() after each operation while debugging.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://163187]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2025-04-17 20:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.