473,289 Members | 1,923 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

desperately needing help with a Server Error

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_Fin ance'
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/For...p-net/200605/1
May 16 '06 #1
4 1273
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

"ka******@comcast.net" <u15580@uwe> wrote in message
news:6057154a5ca93@uwe...
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_Fin ance'
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/For...p-net/200605/1

May 16 '06 #2
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 Dillon wrote:
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/For...p-net/200605/1
May 17 '06 #3
Um, no. You are getting a server error, not a client error.

Try it from another pc to verify.

Jeff
"ka******@comcast.net via DotNetMonster.com" <u15580@uwe> wrote in message
news:6067108e4eba5@uwe...
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 Dillon wrote:
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/For...p-net/200605/1

May 17 '06 #4
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
"ka******@comcast.net via DotNetMonster.com" <u15580@uwe> wrote in message
news:6067108e4eba5@uwe...
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 Dillon wrote:
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/For...p-net/200605/1

May 17 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: JDevine | last post by:
Hey. I posted a info about a program I have written that uses google to get and download files by type and site. I need HELP!!! This program is finished except for 2 features which, having tried...
7
by: Rodney King | last post by:
Hi, I have developed an ASP page which dynamically displays a list of checkbox options based on a SQL statement. Here is my code: <div style="OVERFLOW:auto; Height: 150px"> <table> <% dim...
1
by: rdshultz | last post by:
I'm a complete newbie. Need to insert a Company logo into a database column to use later on in a check printing application. Read how to insert the pointer instead of the object into the column. ...
8
by: frank | last post by:
Below is some code for doing and insert into one of my tables. The inserts do not work because a duplicate key exists, which I want to happen. The problem is, I cannot get access to return an error...
2
by: Lior | last post by:
Hi, I have an ASP.NET website that crashes under heavy load. I use a SQL Server DB. I get around 5500 hits per day. I keep getting the timeout expieried connection pool error. Sometimes it even...
16
by: peshekeedweller | last post by:
Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio,...
10
by: Susan Baker | last post by:
Hi Guys (and girls), I am in a bit of a bind. I'm looking for a simple "proof of concept" C# app (WinForm OR console) that sends a web request to a simple PHP script and receives BINARY data...
6
by: NutsAboutVB | last post by:
Hello, I am a .NET programmer and I have a JPEG image file (from digital camera) of about 109 KB's in size, when I open it and save it (without making any alterations at all, just going to File...
8
by: Dameon99 | last post by:
my program compiles without problems but when i try to run it pauses shortly and then crashes. When i set it to debug it came up with the following message: "An Access Violation (Segmentation...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.