Welcome!

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

SignUp Now!

ODBC Command returns "Unexpected return code hd!"

Aug
2,078
85
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]
 
Back
Top
[FOX] Ultimate Translator
Translate