Hi,
I generated ‘ATSPoints’ Shape file with Point Features.
While querying features from shape file, I am getting ‘OleDbException’.
Code:
ShapeFileFeatureLayer shpATSPoints = new ShapeFileFeatureLayer(Application.StartupPath + @"\MapData\ShapeFiles\GeneratedShapeFiles\ATSPoints.shp");
shpATSPoints.Open();
DataTable dataTable1 = shpATSPoints.QueryTools.ExecuteQuery(“Select * from ATSPoints”);
shpATSPoints.Close();
Error Message :
“The Microsoft Jet database engine could not find the object ‘ATSPoints’. Make sure the object exists and that you spell its name and the path name correctly.”
Please check and clear this issue.
Note : I tried to upload my ‘ATSPoints’ shape files. But limit exceeds more than 3MB.
So I am attaching only ‘ATSPoints.dbf’ file. ATSPoints.zip (1.8 MB)
Hi Peter,
I have a doubt. Using ‘Execute Query’ method for querying, is there any dependency for executing ‘Execute Query’ method.
I mean ‘ODBC driver’ or something else. Main problem is that, at developing side ‘Execute Query’ method working fine.
Where as at Client side having some issues for getting desired result using ‘Execute Query’ method.
Points
Dependency
Performance improve
OleDBException
Please let me know, clear concept of ‘Execute Query’ method.
Do you make sure the code and database is totally the same? Because from the exception it looks the “From” clause don’t works, this clause should point to target dbf file.
The oledb should related with OS, so if the target OS or language is different, maybe it cannot works well.
Maybe you want to check the environment and use some utility to check whether your query statement can works well in target machine.
