I am attempting to read the .dbf file associated with a .shp file to speed up the search for certain metadata, rather than querying the .shp file. I am having great difficulty formulating the correct connection string. I think that the .dbf files are in dBase III+ format, but I'm not sure. At run time I get an error when I open the .dbf file using the connection string below - "code -2147467259 - Unexpected error from external database driver (8961)". Any help in formulating the correct connection string would be much appreciated.
In an act of absolute desperation, I have reconstructed a .dbf file by querying the .shp file and producing a .dbf that is dBase IV using the connection string below, and it works, but I'd like to access the .dbf without having to reconstruct the .dbf file.
I am using an OleDbConnection connection.
Dim BaseConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read;Extended Properties=dBase IV;"
Platform is Windows 10 64-bit