Could Not Find Stored Procedure Error In Asp.net
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Could not find stored procedure - SQLDataSource up vote 0 down vote favorite Other similar questions haven't really been relevant to my problem so I'm making a new one...
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, http://stackoverflow.com/questions/22529644/could-not-find-stored-procedure-sqldatasource just like you, helping each other. Join them; it only takes a minute: Sign up SQL Server 'Could not find stored procedure' without schema name up vote 1 down vote favorite SQL Server 2005/2008, db=user=schema=owner='John', ASP.net 2.0.50727, vb, IIS7 I'm moving website from one server to another. This piece of code works well on old server http://stackoverflow.com/questions/7893299/sql-server-could-not-find-stored-procedure-without-schema-name with SQL Server 2005. Dim sqlCmdVehicle As SqlCommand = New System.Data.SqlClient.SqlCommand("SP_Name", sqlConn) Dim dtVehicle As New DataTable With sqlCmdVehicle .Parameters.AddWithValue("FullStockNo", "N102010") .CommandType = CommandType.StoredProcedure End With sqlConn.Open() sqlAdapter.SelectCommand = sqlCmdVehicle sqlAdapter.Fill(dtVehicle) DB is backed up and successfully restored on new server. When I try to run with new SQL Server 2008 I got an error: Could not find stored procedure 'SP_Name'. pointing at last line. I can see procedures with 'MS SQL management studio' not as dbo.SP_Name but as John.SP_Name When I change System.Data.SqlClient.SqlCommand("SP_Name", sqlConn) into System.Data.SqlClient.SqlCommand("John.SP_Name", sqlConn) all works well, but it's the same with all other procedures and a lot of such kind places in code :( I got http://msdn.microsoft.com/en-us/library/ms189915.aspx, but caller's default schema is correct. Again, all works well on old box. What should I fix in SQL to allow run SP without explicitly mentioned user/schema name? Thank you. ======================================= Unfortunately, I didn't find fine solution. The way I took was search-and-replace SP_Name to John.SP_Name for the whole project. Thanks to all p
DOWNLOAD: C# Corner Android http://www.c-sharpcorner.com/forums/could-not-find-stored-procedure App Version 0.5.3 Released C# Corner Annual Conference 2017 Announced Forums - C# Corner C# Corner Home Technologies Monthly Leaders ASK A QUESTION C# Programming Multi-threading IoT Coffee, Chai Lounge HTML, JavaScript, CSS .NET General Office Interoperability Microsoft Surface Community Services iPhone, iPad Active Directory Printing ReFS Current Affairs Java ADO.NET could not & Database Project Management Silverlight 5 Fun and Jokes JQuery AJAX & Atlas Remoting WCF Job Opportunities JSP Algorithms & AI Reporting Windows 8 Leadership Multimedia, Graphics, Flash Arrays & Collections Robotics and Hardware Windows Azure Mac for Windows Node.js ASP.NET & Web Development Security & Cryptography Windows Store Apps Microsoft Feedback could not find PHP C# Language Setup & Deployment Workflow Foundation Open Source Projects Social Networking C# References Sharepoint WPF Operating Systems TypeScript CLR & .NET Internals Speech & Voice Recognition XAML Language Paid Projects Web Hosting COM Interoperability Tablet PC Site and Forums Feedback Prizes, Awards, MVP Website Management Custom Controls Testing and QA Announcements Students & Beginner Projects Windows Phone 7 Design and Architecture Visual Basic .NET Author Guidelines Test Category Database Embedded Development Visual C++ Bugs and Problems Training & Certification Database General Enterprise Development Visual Studio 11 Forums Feedback Web Development Oracle Games, DirectX, and XNA Visual Studio 2010 Site Feedback & Suggestions Advertising, Marketing, SEO SQL GDI+ and DirectX Web Services Site Spams Android SQL Server General Windows Forms Miscellaneous AngularJS Products LINQ Windows Services .NET Books Cloud Computing Office 2013 Migrating to .NET Cutting-Edge Ask the Author Expression Tools Products Mobile Development .NET 5.0 Career Advice HTML 5 SharePoint