Error Message No more data available to read. on CFMX 6

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

Re: Error Message No more data available to read. on CFMX 6

I get it sometimes when SQL server or CF is cycling - I'd try restarting both. -Joe On Apr 5, 2005 3:09 PM, Mosh Teitelbaum [EMAIL PROTECTED] wrote: All: After moving a site to what will ultimately be its production server, I began receiving the following error message when trying to

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

RE: Error Message No more data available to read. on CFMX 6

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

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

RE: Error Message No more data available to read. on CFMX 6

I thought that this was that rather well documented issue where SQL Server had actually maxed out its connections and was refusing to accept any more but the data direct drivers return the rather less helpful 'no more data' error... If you can, increase your max permissable connections in SQL and

RE: Error Message No more data available to read. on CFMX 6

Here is some info from Steven Erat. http://www.talkingtree.com/blog/index.cfm?mode=entryentry=40F4C7EA-45A6-284 4-7D0C4841EA190125 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start

RE: Error Message No more data available to read. on CFMX 6

Thanks, again, to everyone who replied. I've sent the replies along to the production site's admins (I, unfortunately, don't have direct access to the servers). As before, I'll let you know if/when the problem is resolved and what the ultimate solution was. Again, thanks. -- Mosh Teitelbaum