The error does not occur any time I call the stored procedure. It has been occurring a couple of times a day randomly over the past week. It could occur once in the morning and then later again in the late afternoon.
I'm going to try your suggestion of dumping the sp_help resultset. I'll also start researching database driver hotfixes. Thanks for the suggestions. MC >> An issue seems to randomly occur with our application that > >Does the error occur any time you call that stored procedure, or does it >occur randomly? I can't tell from your description. > >What happens if you run the sp_help stored procedure from your application, >after this error occurs? To do this, you might create a separate page with >just this stored procedure call and a CFDUMP of the resultset. > >Can you upgrade your database drivers to the latest available version from >the Adobe hotfix page? > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
