All Forums Database
seanc 7 posts Joined 09/13
21 Jan 2014
Error: [.NET Data Provider][101151] Too Many Restrictions Supplied

I received the error given in the title when trying to do some fairly simple selects to pull metadata from a Teradata server and wasnt able to find much on this error and how to go about solving it. Any help would be greatly appreciated.

NetFx 346 posts Joined 09/06
30 Jan 2014

You are trying to execute one of the Schema Collections. Please provide additional information; i.e. the name of the schema collection, and the list of Schema Collection Restrictions. I think your application assume that all Schema Collection are common across all Databases. The ADO.NET specification has only 5 common schema collections. The remaining schema collections are Provider specific; therefore you should refer to .NET Data Provider for Teradata documentation:
http://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/webframe.html#SchemaCollectionsOverview.html
e.g. The Columns schema collection accepts three restrictions; namely TABLE_SCHEMA, TABLE_NAME and COLUMN_NAME:
http://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/webframe.html#SchemaColumnsCollection.html
 
 

NetFx 346 posts Joined 09/06
30 Jan 2014

BTW, I recommend that you post .NET Data Provider related questions to the Connectivity forum.

You must sign in to leave a comment.