August 27, 2008 at 12:55 am
Hi guys,
SQL Server Central is great. Great articles.
I came across a new problem in SQL 2005.
When I try to insert a row into a table, lets call it X, it gives me the error
"INSERT failed because the following SET options have incorrect settings: ANSI_NULLS
ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER"
When I insert the row using Microsoft SQL Server Management Studio, it inserts fine, but when I use my application (web), it gives me that error.
Does that mean that I have to set those options to their correct settings in my application everytime I want to insert/update a row?
August 27, 2008 at 1:01 am
yes you have to set the correct settings in the application.
what type of value are you trying to insert.
"Keep Trying"
August 27, 2008 at 7:16 am
Depending on the application, I believe you can set those in your connection manager, rather than having to set them for each insert.
Also, if you use stored procs for your inserts, you can set them for the proc and then be done with it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply