Could Not Find Stored Procedure Error In C#
I just appended the Database or Initial Catalog name/value in the connectionstring! Get 1:1 Help Now Advertise Here Enjoyed your answer? Linux questions C# questions ASP.NET questions fabric questions C++ questions discussionsforums All Message Boards... Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. http://stackoverflow.com/questions/25710958/c-sharp-ado-net-could-not-find-stored-procedure
Could Not Find Stored Procedure Error In C#
current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Join & Ask a Question Need Help in Real-Time? Are you connecting the the same database that the stored procedure was created in ? 0 LVL 1 Overall: Level 1 Message Author Comment by:Sunny_Kumar ID: 333157052010-07-29 Hi Andy, I've
But nothing.Store procedure exists in db. Executenonquery Could Not Find Stored Procedure Browse other questions tagged c# asp.net sql-server stored-procedures or ask your own question. Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies http://stackoverflow.com/questions/22529644/could-not-find-stored-procedure-sqldatasource Does anyone know what this issue is?? =========================================== USE [OnTime_Customer_1] GO /****** Object: StoredProcedure [dbo].[OnTime_sp_Language_List] Script Date: 07/29/2010 13:00:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
The content you requested has been removed. Is three knights versus knight really winning? Hot Network Questions Word for fake religious people Is scroll within a card good or bad? (In desktop) Getting error message when integrating a simple piecewise function Large loan at zero This is my c# code behind to call the stored procedure: SqlConnection con = new SqlConnection(); con.ConnectionString = "data source='example.com';user id='sa';password='password';persist security info=False;initial catalog=Test;Connect Timeout=100; Min Pool Size=100; Max Pool Size=500";
Executenonquery Could Not Find Stored Procedure
When I try and run this sp from an ASP.net c# app, I get the "Could not find stored procedure" error. http://www.aspforums.net/Threads/912166/C-Procedure-created-but-still-get-error-Could-not-find-stored-procedure-InsertRec/ Why did it take longer to go to Rivendell in The Hobbit than in The Fellowship of the Ring? Could Not Find Stored Procedure Error In C# Is three knights versus knight really winning? Could Not Find Stored Procedure In Sql Server I ran the 'aspnet_regsql' tool to enable the application services for my ASP.NET project.
All contents are copyright of their authors. check over here Were Palpatine or Vader ever congratulatory or nice to any of their subordinates? Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'get_ProjectPlan'.Source Error: An unhandled exception was generated during the execution of the current web request. Thanks for ur helpful suggestion.Solved the error. Could Not Find Stored Procedure 'sp_dboption'
Refer to MSDN for more details... Let me know if you have more questions. Regards, Nissim Wednesday, July 09, 2008 7:43 AM Reply | Quote Moderator 0 asked 2 years ago viewed 1173 times active 2 years ago Related 1051Insert results of a stored procedure into a temporary table4ASP.NET - Web.config login error Could not find stored procedure GRM_Novo_Catalogo or GRM_Novo_Cataloge? :) –Arsen Mkrtchyan Mar 20 '14 at 10:14 As correctly ArsenMkrt pointed out, take a carefully look at the name of your stored procedure. his comment is here Wednesday, July 09, 2008 11:52 PM Reply | Quote Moderator 0 Sign in to vote Thanks Nissim.
I access to the db either my a trustedconnection or forcing SA user. Tuesday, May 30, 2006 9:31 AM All replies 0 Sign in to vote Got it! However, I'm still getting the sp cannot be found from ASP.net c# when I run this code: [code] DDL_SqlCmd.CommandText = "Execute "+ this.Get_Product_Name + "_sp_Language_List "+
One of these is a typographical error.
Your Email This email is in use. Treat my content as plain text, not as HTML Preview 0 … Existing Members Sign in to your account ...or Join us Download, Vote, Comment, Publish. Thanks for your help!!!! 0 Featured Post Easy Project Management (No User Manual Required) Promoted by Quip, Inc Manage projects of all sizes how you want. Tuesday, May 30, 2006 9:27 AM Answers 0 Sign in to vote Got it!
Measuring Water with a Holey Cube Theorems demoted back to conjectures Validate Random Die Tippers Is every parallelogram a rectangle ?? The reason it's working with CommandType.Text is because it's a legitimate SQL command like that - if you were to open up SSMS and type that in it'd work as long It runs successfully in SQL server USE [Test] GO /****** Object: StoredProcedure [dbo].[tesproc] Script Date: 09/01/2010 13:00:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[tesproc] -- Add weblink Browse other questions tagged c# sql sql-server-2005 stored-procedures ado.net or ask your own question.
Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Dismiss Username Password Forgot Password Create Account Forums Questions Search Search Does a byte contain 8 bits, or 9? Measuring Water with a Holey Cube Shortest auto-destructive loop Does gunlugger AP ammo affects all armor? This is too weird... The stored proc is executing fine within DB.
Can someone suggest what I am missing and doing wrong here - Please pardon me if it is something very basic as it is quite long since I last worked with Solution 3 Accept Solution Reject Solution SqlCommand cmd = new SqlCommand("[dbo].[HDR_PROFILE_proc]", con); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText="ur stored procedure name"; //add this SqlDataAdapter da = new SqlDataAdapter(cmd); Permalink Posted 7-Nov-12 18:55pm StackQ2.4K But, only from my server its not connecting to the client. Any other suggestions!!!! Also, you don't need to specify dbo.