Problems with VFP Ole Db Provider

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

Hi,

I am having problems sending a DELETE command using the vfpoledb provider.
Funny thing is, when I first implemented this it worked fine now I get the
following exception from the provider about 80% of the time:

"One or more errors occurred during processing of command"
ErrorCode: 0x80040E14

The details of my app and what I have tried so far are below. Any help would
be greatly appreciated.

Thanks

Bill

1) ASP.NET Web service with:
- <identity impersonate="true"/>
- Tried adding explicit userName and password.
2) using OleDbConnection object with:
-ConnectionString = "Provider='VFPOLEDB.1';DSN='myDSN'
-Tried adding Mode=ReadWrite|Share Deny None
3) using OleDbCommand with:
-CommandText = "DELETE FROM mytable WHERE neid = /"NEL0000001/" "
-Tried changing executing exact same SQL on target DB using MS Query
(Works fine)
-Tried an UPDATE command instead, same error.
-Have another command object which uses the same connection to SELECT
form the same table and it works.
Difference is that it is part of an OleDbAdapter and I use Fill command
to fill a DataSet with the results..

4) Database is a VFP 6 and may be installed locally or remote from the Web
Server. Tried both and still get the error.

5) Installing vfpoledb version 8
-Tried upgrading to version 9

6) ADO.NET Code:
try
{
connection.Open();
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
 
Hi Bill,

FoxPro accepts double quotes, single quotes, and square brackets as string
delimiters. Do you have any better luck with "DELETE FROM mytable WHERE neid
= [NEL0000001] " ?
 
Back
Top