Hi Brad,
we’re using Data direct 4.2 with cloverleaf 5.3 on AIX
not sure if this will help but I once encountered a similar “can’t load driver” problem in going from Connect3.8(?) to Connect 4.2 on MS-SQL.
here are 2 things to check:
1) Check that 4.2 actually has the libmyodbc3.so file and not a newer version. In our case we needed to change the driver referenced in the odbc ini file for MS-SQL from CVmsss16.so to CVmsss19.so to match what 4.2 provided. Perhaps you have a similar situation in that 4.2 provides a later version of the driver referenced in the odbc.ini file.
2) Also, connect 4.2 may require a specific version of the ODBC package – I notice your package require statment is not looking for a specific version. When we switched from 3.8 to 4.2 we also went from using the 3.0 version of the odbc package to 6.0.