Joe, Jeff: Thanks for the responses. I'm looking into it and will let you all know whether or not it works.
-- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Jeff Congdon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 05, 2005 3:29 PM > To: CF-Talk > Subject: Re: Error Message "No more data available to read." on CFMX 6 > > > If your CF server is located on a different server than your SQL server, > uncheck "Maintain Connections" in CF admin/datasource setup/advanced > settings" > > In my experience, you get this error when you try to 'maintain > connections' to a remote db. Your cf app makes a query, then you go to > look at something else, 10 minutes later you hit the db again with a new > query and it returns this error. > > HTH, > -Jeff. > > Mosh Teitelbaum wrote: > > >All: > > > >After moving a site to what will ultimately be its production server, I > >began receiving the following error message when trying to perform simple > >SELECT queries. The queries did not throw this exception on > development and > >test machines. Sometimes they work and sometimes they throw > this exception. > > > >Here's the exception diagnostics: > > Error Executing Database Query. [Macromedia][SQLServer JDBC > > Driver]No more data available to read. <br>The error occurred > > on line 24. > > > >Here's one of the queries: > > SELECT Salt FROM Users WHERE Username = (param 1) > > > > (param 1) = [type='IN', class='java.lang.String', value='Admin', > > sqltype='CF_SQL_VARCHAR'] > > > > > >It's running on a Windows 2000 server accessing MS SQL Server 2000, using > >CFMX 6.1. > > > >Has anyone ever seen this message before? Any idea what the > problem could > >be? > > > >TIA > > > >-- > >Mosh Teitelbaum > >evoch, LLC > >Tel: (301) 942-5378 > >Fax: (301) 933-3651 > >Email: [EMAIL PROTECTED] > >WWW: http://www.evoch.com/ > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
