- 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;
I know that this works, as I use it in a 64-bit VBScript file;
The ODBC driver is 64-bit.
I have also tried using [Trans#DBF] in the ODBC Command line, with same results;
I'm probably missing something simple, so any constructive suggestions appreciated.
Joe
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