----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Senthil-Maverick Message 1 in Discussion HI i am getting error in inserting data thru StoredProcedure. i am using ado.net for data Access. when i execute the aspx page the error is : " System.Data.SqlClient.SqlException: INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. " here in this insert query i dont use any arith operations at all. here is my SP create Proc usr_sp_emp @empcode varchar(30), @empname varchar(30), @emplogin varchar(10), @emppass varchar(10), @empclue varchar(10), @empans varchar(10) as Insert into emp(empcode, empname,login,pass,clue,answer) values(@empcode,@empname,@emplogin,@emppass,@empclue,@empans) Also to test the SP i used the same fields and created another new Table ,and created another new SP ,when calling the new SP to the new table, it is working fine. so whats the probs with the old SP, old table??? where did i go wrong??? ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
