MBR IT/.NET 247 : Error when project was deployed on ASPFriends.com 'aspngfreeforall' list

Error when project was deployed

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngfreeforall' list.

Anthony Merante

I have a project that is functional on my DEVSERVER but when I deployed it to my IPP, I'm getting an error.

THe Error is this:
Insert Error: Column name or number of supplied values does not match table definition.
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.

Exception Details: System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition.

My code and my SQL DB is exactly the same on both servers. I went NUTS trying to figure out what generated the error and I've concluded that it must be a WRITE Permissions that isnt set right even though i get the Error Insert Error: Column name or number of supplied values does not match table definition.

I get that error whenever my APP is trying to write to a table in my DB. Its fine on my Devserver and both my Devserver and IPP are using SQL2000.

Can anyone shead some light on this?

Reply to this message...

Vittal

Hi
I believe there can be two reason's

1. Check the number of column's you are passing matches the number of columns in the table

2. Capture the actual sql statement posted to the server and try to execute the same sql statment to find whether it gives error

Are you sure that table columns are not changed ?

vittal

----- Original Message -----
From: Anthony Merante
To: aspngfreeforall
Sent: Friday, August 09, 2002 3:18 AM
Subject: [aspngfreeforall] Error when project was deployed

I have a project that is functional on my DEVSERVER but when I deployed it to my IPP, I'm getting an error.

THe Error is this:
Insert Error: Column name or number of supplied values does not match table definition.
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.

Exception Details: System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition.

My code and my SQL DB is exactly the same on both servers. I went NUTS trying to figure out what generated the error and I've concluded that it must be a WRITE Permissions that isnt set right even though i get the Error Insert Error: Column name or number of supplied values does not match table definition.

I get that error whenever my APP is trying to write to a table in my DB. Its fine on my Devserver and both my Devserver and IPP are using SQL2000.

Can anyone shead some light on this?
| ASP.net DOCS = http://www.aspng.com/docs | [aspngfreeforall] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/aspngfreeforall = JOIN/QUIT | news://ls.asplists.com = NEWSGROUP

DISCLAIMER
---------------------------------------------------------------------------
This email message and any attachments is confidential and intended only for
the use of an individual or entity named above and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If you are not the intended recipient, you are notified that any
dissemination, distribution or copying of this email is strictly prohibited.
If you have received this email in error, please notify us immediately by
return email or Click here to reveal e-mail address and destroy the original message.
Opinions, conclusions, and other information in this message that do not
relate to the official business of SPAN, shall be understood to be neither
given nor endorsed by SPAN
________________________________________
Mails are Scanned and Filtered for Virus
Click here to reveal e-mail address

Reply to this message...

System.Data.SqlClient.SqlException

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com