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.
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:
e.g. The Columns schema collection accepts three restrictions; namely TABLE_SCHEMA, TABLE_NAME and COLUMN_NAME:
BTW, I recommend that you post .NET Data Provider related questions to the Connectivity forum.