An issue seems to randomly occur with our application that results in the following error any time we try to insert records in our usage database using sproc called 'InsertUsage':
"[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'InsertUsage'. " I know the stored procedure is on the server and works. When this error occurs, the only way to resolve it is to restart the CFMX service. It's as ColdFusion "forgets" how to find the usage database datasource. I also have a query that results in the same error above but instead of listing the sproc name, it displays the usage table name. The CF logs in the adimnistrator don't show anything other than the same error I've listed above. We're racking our brains to figure out what's going on. It seems to be completely random and we know our database server is running fine. I can run queries using query analyzer against the same tables that ColdFusion says it can't find. Has anyone seen this sort of thing before? Any help would be greatly appreciated! We run: CFMX 7.0.1 IIS 6 SQL Server 2000 Regards, Merritt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
