See chapter 1 of the odbc_jdbc guide for filemaker.
it tells you what you can and can not do with xdbc and filemaker AND tells you how to set it up.
Thank you. I got it. I'll look at it.
binary is not a supported data type for ESS:
Also note to be careful with how you read "it suggests..." about ESS. ESS is just one of the options to exchange/work with data from another source, but there certainly is no recommendation anywhere to always use it or any implicit statement that it is superior than the alternatives. It really depends on what it is you want to achieve.
In your case ESS is out because of the lack of support for binary.
If Oracle can give you a Base64-encoded string of that binary then it is just text that you can get and re-encode in FM to get the image.
I can't find any ODBC driver for my Mac. This is what I see on the Oracle web site:
"As of now Oracle ODBC driver is not supported on MacOS platform. That's why ODBC Instant Client Package is missing in that page."
This was from 2014. I don't know if it's still true or not, but, I didn't see anything on the site.
I'm on a Mac. My server version will reside on a Windows server, but, I'd really like to develop on my Mac.
Wow! OK. Thanks. Guess I'll get those. Shouldn't this be in the FM doc?
not specific, but this is usually a starting point for ODBC/JDBC:
and that points to:
this is specific:
"Which ODBC data sources/drivers are supported with External SQL Data Sources?"