ODBC Command returns "Unexpected return code hd!"

[Joe Caverly]

I am trying to use the ODBC Command, but it returns "Unexpected return code hd!"

This is my ODBC Command line;

E:\Utils>odbc "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\utils;Extended Properties=dBASE IV;User ID=Admin;" "Select * from Trans.DBF"
Unexpected return code hd!

I know that this works, as I use it in a 64-bit VBScript file;

Set dbf = CreateObject("adodb.Connection")
dbf.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\utils;Extended Properties=dBASE IV;User ID=Admin;"

Set Results =  dbf.Execute("Select * from [Trans#DBF]")

The ODBC driver is 64-bit.

I have also tried using [Trans#DBF] in the ODBC Command line, with same results;

Unexpected return code hd!

I'm probably missing something simple, so any constructive suggestions appreciated.

Joe

 

[Joe Caverly]

I still cannot get the ODBC command to work for me;

odbc /o "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\utils;Extended Properties=dBASE IV;User ID=Admin;" "Select * from Trans.DBF"

returns

Unexpected return code hd!

Joe

     _x64: 1
   _admin: 1
_elevated: 1

TCC  30.00.21 x64   Windows 10 [Version 10.0.19044.3086]