Stored Procedure Error - No more data available to read.

I just started using stored procedure with Cold Fusion. Sometimes, I get this error..
Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]No more data available to read.

If I refresh the page, sometimes it will show the data, other times I get the error. What's causing this?

<cfstoredproc procedure="Display_Products" datasource="#request.datasource#" username="#request.username#" password="#request.password#">
<cfprocparam cfsqltype="cf_sql_integer" value="#category#">
<cfprocresult name="spProducts">
</cfstoredproc>

<table cellpadding="2" cellspacing="2" align="center">
<tr>
<cfoutput query="spProducts" startrow="#Variables.StartRow#" maxrows="#Variables.RecordsPerPage#">
<td valign="top">
<div align="center" class="buttions"> Click image for larger view<br>
<a href="/#categoryid#/#image#"><img src = "/#categoryid#/thumbnails/#image#" border="0"></a><br>
#product#<br>
<strong>#DollarFormat(price)#</strong></font></div>
<br><br>
</td>
<cfif spProducts.CurrentRow MOD 4 IS 0>
</tr>
<tr>
</cfif>
</cfoutput>
</tr>
</table>
LVL 8
JRockFLAsked:
Who is Participating?
 
sigmaconConnect With a Mentor Commented:
I know that just posting a link might not help, but what you describe sounds like a recent driver issue discussed here:

http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=684306

Make sure this is the problem you have, and then download the reverse-to-6.0-update:

http://download.macromedia.com/pub/coldfusion/drivers/3.1/cfmx60_u3.zip

unzip it and find

macromedia_drivers.jar

then replace that file in you CFMX installation in the /lib folder

MAKE A COPY OF THE OLD FILE FIRST SO YOU CAN GO BACK IF NEED BE.
0
 
JRockFLAuthor Commented:
Hey there. I tried the file you suggested. So far so good. I had read something similiar and replaced the same file with a different one but that didnt fix it.

The one I used previously was newer then the one you suggested. Hopefully it will continue to work.

Thank you.
0
 
sigmaconCommented:
OK. just to clarify: Yes, the file I suggested is OLDER, and as such contains BUGS that the newer file was supposed to FIX. The forum article I linkted to earlier goes into detail about that. It's rare to encounter this bug in common scenarios. The OLDER file doesn't have the NEW BUG -the one the one that bugs you!
0
 
JRockFLAuthor Commented:
Cool! It has been working fine for me now with that older file. Thank you
0
All Courses

From novice to tech pro — start learning today.