Turn off "maintain connection across requests" in CF Admin under Datasources => Your DB Name = Advanced.
This could be the problem. sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 10:07 am To: CF-Talk Subject: MS SQL - Cannot Find Stored Procedure Importance: Low I've created the stored procedure in the Enterprise Manager on our Dev Server. Its the same code that's used on our live site so I know it works. However, Coldfusion returns an error that says the stored procedure cannot be found. Another thing : is that when I go to run the stored procedure again ( see code below ), it tells me that it cannot find it in the system catalog. ( whatever that means ). But it DOES appear in the stored procedure list. Checked permissions and they seem fine as well. Code at top of the stored procedure... IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Get_Adverts' AND uid = user_id('myuid') AND type = 'P') DROP PROCEDURE Get_Adverts GO ...... remaining code in here ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209397 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
