desperately needing help with a Server Error

K

kaosyeti

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. ***
 
J

Jeff Dillon

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
 
K

kaosyeti

um... i don't have access to the code. it's not my website. the site is a
vendor of my company's and they keep telling me that my pc is the problem.

Jeff said:
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
hey... i know NOTHING about sql server, .net framework or probably
anything
[quoted text clipped - 59 lines]
there
was the correct location. ***
 
J

Jeff Dillon

Um, no. You are getting a server error, not a client error.

Try it from another pc to verify.

Jeff
[email protected] via DotNetMonster.com said:
um... i don't have access to the code. it's not my website. the site is
a
vendor of my company's and they keep telling me that my pc is the problem.

Jeff said:
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
hey... i know NOTHING about sql server, .net framework or probably
anything
[quoted text clipped - 59 lines]
there
was the correct location. ***

--
Greg

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

Jeff Dillon

I see that it works if you are a local admin on your workstation.

Possibly you have have configured your normal user account to not accept
cookies or scripting, so session information can't be persisted.

Perhaps add this site to your IE "safe" list. Check your browser settings
under Tools/Internet Settings. Compare those settings between you and as an
admin.

And the .NET framework mentioned is on the server, not your workstation.
This is a server error, keep in mind.

At any rate, your vendor has unhandled exceptions (poor coding)

Jeff
[email protected] via DotNetMonster.com said:
um... i don't have access to the code. it's not my website. the site is
a
vendor of my company's and they keep telling me that my pc is the problem.

Jeff said:
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
hey... i know NOTHING about sql server, .net framework or probably
anything
[quoted text clipped - 59 lines]
there
was the correct location. ***

--
Greg

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,902
Latest member
Elena68X5

Latest Threads

Top