how to use stored procedure

[With_problem]

i am trying to use stored procedure to store data in my dtabse getting from remote server....but i dont know from where to start... i have done ole db connection to database with the help of ATL consumer wizard....now how to proced further...can anybody help me....

[Rajesh R Subramanian]

You need to write the stored procedure in your database. Then test it from your app. Here[^] is an example. Googling will give you plenty of results to start with.

---

Nobody can give you wiser advice than yourself. - Cicero ப்ரம்மா

[With_problem]

o yes stored procedure are wrriten in dtabase...now i am looking for how to use them on my project in vc++...should i need to use some classes or what....

[Rajesh R Subramanian]

You can use the CDatabase class to interact with databases using ODBC. If you are using DAO, then you can use CDaoDatabase class. PS: Are you looking for the ExecuteSQL keyword?

---

Nobody can give you wiser advice than yourself. - Cicero ப்ரம்மா

[With_problem]

I am not using odbc but i am using OleDb connection for sql server....any idea

[Rajesh R Subramanian]

No matter what methodology you adopt to connect to a database. SQL is going to remain the same. I assume you're able to connect to your database from your app. Have a look at this sample[^] which demonstrates how to call a stored procedure from c++. Also give a chance[^] to google.

---

Nobody can give you wiser advice than yourself. - Cicero ப்ரம்மா