Running my query gives the next error statement.
The expected data length is 5, while the returned data length is 1
or in other words
'MSDASQL' returned an unexpected data length for the fixed-length column
By using: DBCC TRACEON(8765)
As first line in my query was the solution.
Don't know why but it works!!
Example:
DBCC
TRACEON
(8765
)
Select * from openquery(Transoft
, ' select field1, field2 from table)
Transsoft = driver I use