I have the Database Connectivity Toolset and it does not appear to directly support the datatypes defined in the toolset. My first issue is relative to storing numerical arrays. I am using MySQL Server 5.0. I get an error when trying to create a TABLE with a column to store a numberical array. The Toolset command syntax used to put this array in the table uses IMAGE which does not seem to be supported by MySQL.
Are there any revisions that allow the DB Toolset to directly support MySQL? Are there any workarounds other than going through all the code and perhaps add other commands specifically for MySQL e.g. BLOB.
Mike