Force Result Set to Return Column Names and Not Column Titles

Database

Force Result Set to Return Column Names and Not Column Titles

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?

Bryan

2 REPLIES
Teradata Employee

Re: Force Result Set to Return Column Names and Not Column Titles

Is your linked server a Teradata system?

Teradata Employee

Re: Force Result Set to Return Column Names and Not Column Titles

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.