Welcome!

By registering with us, you'll be able to discuss, share and exchange private messages with other members of our community.

SignUp Now!

ODBC Command returns "Unexpected return code hd!"

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

This is my ODBC Command line;
Code:
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;
Code:
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;
Code:
Unexpected return code hd!

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

Joe
 
I still cannot get the ODBC command to work for me;
Code:
odbc /o "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\utils;Extended Properties=dBASE IV;User ID=Admin;" "Select * from Trans.DBF"
returns
Code:
Unexpected return code hd!

Joe
Code:
     _x64: 1
   _admin: 1
_elevated: 1

TCC  30.00.21 x64   Windows 10 [Version 10.0.19044.3086]
 

Similar threads

Back
Top