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

madinewala · Answer

Hi Mahesh and others Thanks a ton for your replies... well my problems is solved. Actually the problem was in my stored procedure itself. I corrected it to return a value and it worked fine.. THanks irfan

Mahesh Chand · Answer

Since you were using SqlClient I suppose you are using SQL Server. If you are using SQL Server why do you want to use OLEDB data provider? It's not easy to guess from your question. You have to debug where the problem is? I dont see any issue executing stored procedures with OLEDB data provider. Eleborate more.

spgilmore · Answer

Don't know the answer but I have some suggestions that might help reveal it.. 1) name the field in your query: select count(*) as cnt from IfanTab where irfan='good' 2) Are you changing the connection from a sqlconnection to an oledbconnection? 3) Why would you want to use an oledbconnection when you can use a sqlconnection? 4) What is the provider that you specify in the connection string? Can you get this connection string to work in a regular ADO app? Can you try it in VB or something? I could email you such an app. It sounds like you probably connect because your problem comes on the exec of the storedproc not the connection.open() but anything's possible.