Forgot to say that in Windows7x64 it was FM Pro13, and another try was on WIndows8x32 with FM Pro12 - same result
As I understand it (and I haven't needed to work with ODBC so I'm going from memory on what I have read in several sources), You'd need to use the ExecuteSQL script step, not the function to query the data source and this would be used to copy data into a field in the database so you'd copy data into FileMaker, manipulate it and then use a different query to push it back to the data source.
The ExecuteSQL function, on the other hand, was used to facilitate SELECT only queries of actual FileMaker tables.
Thanks for answer !
I was looking how to use Execute SQL script step to get data from any table but there's no way to pass data from script step to variable or field. It seems that this step is not designed to return data, but only to send SQL query to driver. When I used SELECT there was no result, even Get (LastODBCError) didn't return anything (which I think is normal).
ExecuteSQL function can be used to query outside FileMaker, I tried with MySQL drivers and it worked.
I'm not searching for solution here, but trying to understand this limitation. Or I got something very wrong :)
Unfortunately, MS Access is not one of the database systems that FileMaker supports as an External Data Source.
And, you are right. Execute SQL script step is not designed to retrieve data via SELECT SQL statement.
You need to use Import Records script step to get data from an MS Access database.