Choose ODBC or DB-Library?

I am designing a project which will use some important features such as transaction,various locks provided by Microsoft SQL Server 7.0. I am not sure if ODBC 3.0 can achieve this goal.
Can I execute full set of Transact-SQL through pDataBase->ExcuteSQL(...)?
Are following codes valid(Perform transaction using Transact-SQL)?

pDataBase->ExecuteSQL("BEGIN TRANSACTION");
pRecordSet->OPEN(...,"Select * from Table1 with (updlock)",...);
...
pDataBase->ExecuteSQL("COMMIT TRANSACTION");



If I cannot achieve this goal,I have only to use DB-Library for C.

Thank you for your kindly help!!!


YiZeng