using stored procedures with OleDB in C#

Question

Hi there!! I'm facing problem using stored procs with OleDB. I have a small stored proc. that returns me the count or no. of rows as a return val. my query is "select count(*) from IrfanTab where irfan='good' This works fine with SQLClient in C#, but returns 0 when I change the DB provider to OLEDB. any solution?? THanks, irfan