Hello all,

I'm looking for some info on the ADO Stream object. I'm trying to access a MySql database in ASP.

I can create the connection object, generate a recordset etc without problems and return the text in the various fields with response.write etc. My problem comes with dealing with the last field which is a large text field (about 40k of text in some records) I understand that I need to use a Stream object and read/writetext etc but my docs only detail using this with a file object. Could anyone give me some idea on how to set this up with a recordset or provide me a URL? I cannot find anything on w3schools to help, and I'd buy to required book if I knew that it would work, however I don't - yet!

Thanks in advance.

Sorry, forgot to include. This is IIS running on Win2k SP3 using ASP v3.0 and ADO 2.5

Are you timing out when you get to this last record? If that is the case, you need to add a command such as COMMANDTIMEOUT parameter to be equal to a certain number of seconds in order to allow you to complete the process before a timeout occurs.

HTH

I need to know what you exactly will deal with the largr text field so I may suggest the way out.