Solved

Stored Procedure Error - No more data available to read.

Posted on 2004-10-23
981 Views
Last Modified: 2013-12-24
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>
0
Question by:JRockFL
    4 Comments
     
    LVL 8

    Accepted Solution

    by:
    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
     
    LVL 8

    Author Comment

    by:JRockFL
    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
     
    LVL 8

    Expert Comment

    by:sigmacon
    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
     
    LVL 8

    Author Comment

    by:JRockFL
    Cool! It has been working fine for me now with that older file. Thank you
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    884 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now