Help : Unable to write to file buffer

Hi everyone,

I am using ASP page to request data from MySQL, things were just fine at the beginning but somehow stuck at a point when the browser shown an error message liket this :

ADODB.Recordset.1 error '80004005'


SQLState: S1000
Native Error Code: 0
[INTERSOLV][ODBCCUR lib] General error: Unable to write to file buffer

/index.asp, line 323

The particular ASP script that I used look like this :

<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={MySQL};Database=mydatabase;Server=mysql.ab cxyz.com;UID=mummum;PWD=abcabc"
Set rs=Server.CreateObject("ADODB.Recordset")
sql="Select * from NewsUpdate order by masa desc"
rs.open sql,conn,3,3
%>
<%while not rs.eof
title=rs("title")
tarikh1=rs("tarikh1")
tarikh2=rs("tarikh2")
file1=rs("file1")
file3=rs("file3")
media=rs("media")
masa=rs("masa")
NewsID=rs("NewsID")
%>
<li><a class="5" style="text-decoration:none" href="../ASP/news_page.asp?ID=<%=NewsID%>" target="_blank><%=title%></a>
<%
rs.MoveNext
wend
%>

The problem : Let say there are 10 data in MySQL need to be extrated, and this piece of ASP work just find for the first 6 data, when it comes to the 7th, the error message shown above pop up and the rest just stuck there.

Just wonder anybody has the crystal ball or solution.

Thanks in advance.

Birdy

Show us the code that occurs on line 323 (i.e. the one that's causing the error.) Also, tell us what data types are for each field that you think might be causing the problem.

Hi Stumpy,

Since I tried the script again, that particular line which coused error had been changed to 769, the error message still the same though, below is the script which the line 769 fall in:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={MySQL};Database=birdylaw;Server=mysql.xyza bc.com;UID=mummum;PWD=123123"
Set rs=Server.CreateObject("ADODB.Recordset")
sql="Select * from Yesterday order by masa desc"
rs.open sql,conn,3,3
%>
<%while not rs.eof
title=rs("title")
tarikh1=rs("tarikh1")
tarikh2=rs("tarikh2")
file1=rs("file1")
file3=rs("file3")
media=rs("media")
masa=rs("masa")
NewsID=rs("NewsID")
%>

<li>
<a href="../ASP/news_page_yesterdaynews.asp?ID=<%=NewsID%>" target="_blank"><%=title%>
(I belive this is the line 769 or somewhere around here)</a>
<font> <%=media%></font>
<font> <%=masa%></font>
<br>

<%
rs.MoveNext
wend
%>
</menu>

The data type are:
title : mediumtext
tarikh1 : mediumtext
tarikh2 : mediumtext
file1 : mediumtext
file3 : mediumtext
media : mediumtext
masa : time
NewsID : decimal

Thanks.

Birdy

Hi Stumpy,

The error was solved.

You were right, something wrong about the type of data, thery were just too large originally, after reset the type of data, everything works just fine.

Thanks for the hints.

Birdy