We've had a similar problem a few months ago... I'm not exactly sure what caused it, but it seems that the CDATA table was owned by a different user, and therefore coldfusion was not seeing it, because it was not owned by dbo.
Check your database, I bet that's what happening. As to the cause, no idea... been running without issues before then and since then. (I've recreated the tables to fix the problem). Maybe it's a CF bug... -----Original Message----- From: Joshua O'Connor-Rose [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 27, 2005 5:32 PM To: CF-Talk Subject: client vars and cdata I know, I know, using client variables is not the best practice ever realy but we are trapped by third party application and they are married to them. We recently saw this happening on our cfmx server environment -------------------- Operation failed on the data source named "ClientVar". Reason of failure "[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'CDATA'." -------------------- Now our systems guy thinks that it had to do with the fact that there were 25000 records that is until he saw production and noted that there were over 100000 records in the clientVars database. Any thoughts on workarounds or means to make this better. or what may be causing it. Thanks in advance Joshua O'Connor-Rose -All is Good ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227732 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
