<div>
could you post your query and the underlying table(s) design?
</div>


could you post your query and the underlying table(s) design?

<div>
<div class="content wysiwyg-content">
When I am at the Configure Data Source, right at the test query part I get this error<br />
<br />
There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.<br />
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.<br />
<br />
The thing is when I execute query, it has giving me all the data I need.<br />
Why I get this error?
</div>
</div>


When I am at the Configure Data Source, right at the test query part I get this error

There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

The thing is when I execute query, it has giving me all the data I need.
Why I get this error?

executing query error.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.