Re: desperately needing help with a Server Error

Your call to the stored procedure is failing, because you are not passing
the correct number of arguments (like the error says)

Search your code for sp_MW_tblDeals_Update_Main_Finance and see where/how
the parameters are set.

Then open SQL Enterprise Manager, and drill down to this stored procedure
and open it, and look for the parameters it's expecting

Jeff

"kaosyeti@xxxxxxxxxxx" <u15580@uwe> wrote in message
news:6057154a5ca93@xxxxxx
hey... i know NOTHING about sql server, .net framework or probably
anything
else on sql monster. i am a novice access user, self-taught for about 9
months now and have only a basic understanding of vba. that being said, i
need some help...8)

i have a web site that i used to routinely visit for my job that performs
calculations for monthly car payments based on about 20 user-entered
fields.
the problem is that about 3 months ago, it stopped working -- when you hit
the calculate button, the screen will seem to refresh as normal but either
nothing comes up in the monthly payment box, or if it's there, when you
click
the print button (and you HAVE to click this button as opposed to printing
right from internet explorer), the following error occurrs:

Server Error in '/' Application

.Net SqlClient Data
Provider::Procedure'sp_MW_tblDeals_Update_Main_Finance'
expects parameter '@lp_mny_D_Selling_Price', which was not supplied.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Stack Trace: (i will repost this if you need to see it -- it's a little
lengthy)

Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
ASP.NET
Version:1.1.4322.2300

Now, here's the weird bit. this is NOT a problem with the web site. it
isn't a problem with internet explorer (99%) or adobe. i know this
because
if i log off of windows under my normal user id, and log in as admin, it
will
work. the admin id has minimal files, software, etc.. just like most pc's
i'm sure. i uninstalled the .net framework and reinstalled it using
version
2.0 and i still get the same error identifying version 1.1.4322.2300. I
have
called tech support for this web site but they are useless, trying to have
me
delete temp internet files and cookies and not much else. i have created
a
new user id on this pc just to be able to use this web site (which despite
my
slow pace at adressing this issue due to lack of company pressure has
become
a hot-button for my bosses all of a sudden).

i apologize for the way in which this question was worded, if it even
makes
sense at all. i tripped on to this board from access monster and thought
it
a stroke of dumb luck, considering i had no idea of where to turn for help
with this. thanks for looking.

*** i posed this on sql server monster as well, not knowing if here or
there
was the correct location. ***

--
Greg

Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/asp-net/200605/1


.