Re: Foreign key constraints problem in SNC SQL Native client
- From: "Scott Morris" <bogus@xxxxxxxxx>
- Date: Tue, 1 Apr 2008 10:50:38 -0400
I think, I would not give clear idea about this issue. let me puting
it in differant way.
This isn't any more clear and isn't any more useful than what you originally
posted. With such information, the best anyone can do is speculate; the
absence of responses indicates that there simply isn't enough useful
information. I seriously doubt that the change from MSS to SNC has anything
to do with this particular problem. My best guess is that you have migrated
to a new DB server (perhaps changing the version used from 2000 to 2005) and
have not used the same installation/configuration values from the original
server/DB. Either that or your referential integrity/schema has changed
somehow.
You need to take the time to figure out the sequence of "commands" sent by
your application to the database and at least understand if this sequence
differs (and how) from that issued by your previous version/configuration.
You can use the Profiler to identify the statements executed by your
application - take these statements and execute them using any other query
tool and see if they produce the error. I'm guessing that they will - if
so, that indicates your client application is not the problem. If your two
versions of the application execute different sets of statements, then the
problem starts with the client application. Either way, you need to do some
basic debugging work.
Based on your original post, I would have expected your previous
configuration to also generate a constraint error since you cannot delete
the parent before deleting the child. The only way this would not have
caused a constraint problem is if you had actively taken measures in the
schema to compensate for this (using an instead-of trigger or defining the
foreign key constraint with the delete / cacasde option). If this was the
situation, then that takes us back to my previous point - your schema
appears to have changed.
.
- References:
- Re: Foreign key constraints problem in SNC SQL Native client
- From: brijeshjmishra
- Re: Foreign key constraints problem in SNC SQL Native client
- Prev by Date: Re: Foreign key constraints problem in SNC SQL Native client
- Next by Date: Re: Connection Established Successfully..Error during the log proc
- Previous by thread: Re: Foreign key constraints problem in SNC SQL Native client
- Next by thread: Re: Foreign key constraints problem in SNC SQL Native client
- Index(es):
Relevant Pages
|
