Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: MS Access and Win32::ODBC problem

by gav^ (Curate)
on Aug 30, 2002 at 20:51 UTC ( #194249=note: print w/replies, xml ) Need Help??


in reply to MS Access and Win32::ODBC problem

I think the problem you may be having is that the data returned by the 246th row is too big to fit in the buffer. I've had similar problems with Access. If raising the buffer past 3,024,000 bytes is not a possibility you should look at reducing the amount of columns returned. It also seems wasteful to do a 'SELECT *' and only use one column.

Hope this helps...

gav^

Replies are listed 'Best First'.
Re: Re: MS Access and Win32::ODBC problem
by Washizu (Scribe) on Sep 03, 2002 at 14:16 UTC

    Good ideas, but nothing seemed to help. I tried selecting different sets of data from the table and all of them seemed to break at 240-250 records. I tried selecting only a single column and that didn't work either. Thanks for the suggestions.

    -----------------------------------
    Washizu
    Acoustic Rock

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://194249]
help
Chatterbox?
[Lady_Aleena]: Lax, that would take it down to a little less than 100 characters. The module name is nearly 80 characters long.
Lady_Aleena has fumble fingers today.
[Lady_Aleena]: Sorry for the name typo LanX.
[LanX]: never lad_ena!
[LanX]: ;)
[Lady_Aleena]: IMO, Fancy::Join:: Grammatical isn't bad, but RolePlaying:: WorldBuilding:: WorldBuildersGuide book::ClimateTerra inSubsistance is on the long side.
[Lady_Aleena]: I'm still in reorganizing/ renaming mode.

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2017-05-24 22:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?