Is there a connection string attribute or some other setting which can be used to force the returned result set to use column names for the header instead of column titles? I've found a setting in the ODBC admin panel entitled 'Use Column Names' however whether it is checked or not it still returns column titles if the columns have them. I also found a setting in the Teradata SQL Assistant which actually does work however I need to find a way to set up my linked server under MS SQL Server 2008 to use the column names as well. Any ideas?
Anyone had any luck with this? Trying to create a Teradata linked server IN MS SQL and but select from views that have column title attributes.