Monday, March 2, 2015

Could not find stored procedure 's'

Please post the C++ code you have. Without it we are completely in the dark and all you will be offered are wild guesses, which hitherto has proven to be off the mark.


And we may even be if you post the code. This is a forum to T-SQL problems, and this is clearly an error in your C++ code. Either an error with the C++ as such, or there is an error in your call to SqlExecdirect.


The message Syntax error or access violation is a message from ODBC, not from SQL Server. It usually indicates that you an error in the syntax that is intercepted by ODBC.


I would suggest that you use your C++ debugger to inspect more closely what you are passing to SqlExecDirect.





Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

No comments:

Post a Comment