sql server - ASP.Net: SQL Insert query not being called -
i have webpage uses ado.net calls stored procedure , passes variables insert item. within webserver, works, within production server not working. there anyway @ sql server , see if returning error?
what "is not working" mean? how know asp.net code calling anything? possible connection string pointing wrong place? don't have ability put try / catch in code calls stored procedure, , output or log errors? tell run profiler or check sql server error log, i'm not convinced code connecting server @ all, never mind right one. place start debugging in app, not in sql server. verify you're connecting right database , entering code calling stored procedure. if it's still "not working" need narrow down means. either works or you'll error message (unless have empty catch{} handler).
Comments
Post a Comment