Hi Kevin,
I have the same problem too but corrected it by inserting the code below. Try this code, insert it in your program.
.
.
.
>Source=c:\\masonry\\data\\mydata.dbc"
OleDbCommand strCmd;
strConn.Open();
strCmd = New OleDBCommand("SET TABLEVALIDATE TO 0", strConn);
strCmd.ExecuteNonQuery();
>OleDbDataAdapter da = new OleDbDataAdapter(cProcName, strConn);
.
.
Loy
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement