I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code)
I have read lots of technical articles but i'm a bit confused ...
with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better solution; i read something about sql client .h but i haven't found sample in C code so it 's not clear to me the use of this library

Can you tell me what is the best way to approach te problem and where to find some code example (connect sql server 2005 from C code, executing query ..)

thanks !!!