auto increment in odbc

I have tried to create a table with auto_increment number via odbc. I use sql commands such as
"create table Table1 (off_inx int not null auto_increment, rid int,attribute real)" or
"create table Table1 (off_inx int identitty(1,1), rid int,attribute real)" but none of them correct.
The error generates that syntax error. I'm not sure whether odbc not accept this sql but I don't know
how to check or how to correct it, andhow to create a table with auto number via odbc.

If I anyone knows, please help.

Thanks

Creating a table and setting the auto increment value is a RDMS-specific issue. Google the name of the RDMS you are using and something like "auto increment"