> 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.
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:267694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
