.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
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




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification