I installed the trial version of the driver "Devart ODBC Driver for xBase" to perform some tests with the .Netcore to read some tables of Visual Fox in the directory C: \ test, below I am putting the code that I am testing with C #.
Code: Select all
using (var conexao = new OdbcConnection("DSN=MYDSN"))
{
conexao.Open();
using (var comando = conexao.CreateCommand())
{
comando.CommandText = "select * from teste";
using (var tabela = comando.ExecuteReader())
ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL
The test table has the following structure
CODIGO N(5)
DESCRICAO C(10)
WITH THE FOLLOWING CONTENT
Codigo = 1
Descricao = “Teste”
Since I'm with the trial version, I only have 20 more days to be able to test and evaluate if we should buy and we'll get what we need
Thank you
Nelson