how to call stored procedure in c++ using odbc

[ajitm]

hi i am using odbc and i want to call stored procedure in sql server using odbc
so what are the steps i have to fallow to call the stored procedure
thanks in advance.

[kbw]

Checkout SQLAPI++.
http://www.sqlapi.com/

[ajitm]

hi i am using odbc and c++ to call sp_rename procedure in sql server.
the procedure is sp_rename("old_tblname","new_tblname")

for that i have made sqlprepare() statement passing parameter as ,handle to statement, sp_rename(?,?),and length of second parameter)

it returns success.

then i have tried for sqlbindparam function passing parameter as,
sqlbindparam(m_hstmt, 1 ,sql_cha , sql_char, strlen((char*)str1), 0 , &str1 , 0)

which also returns success.same function i have wriitten for second parameter with value str2(str1 and str2 stores actual value to pass the procedure.)

sqlbindparam function returns success but further i move to call sqlexecute(h_stmt) it returns FAILUIRE

so plz how can i made the changes in sqlbindparameter function so that i can get success in sqlexecute method.


thanrks in advance.