I thought this would be easy, but I'm stumped...
I have a stored proc in VFP...let's say it's called GETDATA. It brings back several rows of data. I'm using the newest VFP OLE DB provider.
here's my code...it generates an unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
string cProcName = "exec getdata()";
string strConn = "Provider=VFPOLEDB.1; Data Source=c:\\masonry\\data\\mydata.dbc"
OleDbDataAdapter da = new OleDbDataAdapter(cProcName, strConn);
DataSet DsReturn = new DataSet();
da.Fill(DsReturn);
It doesn't matter if I hard code the connection string, or use a connection object...I get the same result...the error is on the 'fill' command. It also doesn't matter if I code the procname as 'exec getdata', or 'getdata()'...no combination seems to work.
The stored proc runs fine if I run it in VFP.
Help!
Thanks,
Kevin