ODBC connection to table with more than 255 fields

cdudley · #1 (**permalink**) 08-29-10, 12:49

I am connecting to a table with more than 255 fields. Is there a way to choose which 255 fields the ODBC connection pulls?

Sinndho · #2 (**permalink**) 08-29-10, 15:22

On the server, create a view that has 255 columns or less and link your application to that view. So many columns in a single table usually means that there is a problem with the database schema.

healdem · #3 (**permalink**) 08-29-10, 18:04

use

Code:

select my, comma, separated, column, list from mytable

instead of

Code:

 select * from mytable

myle · #4 (**permalink**) 08-30-10, 06:09

my question would be why a table has more than 255 feild

Internet Services

Web Development

Digital Marketing

Consumer Tech