OK, sorted. I used the previously mentioned tequnique but changed the
connection string to...
DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=intranet;UID=****;PWD=****;OPTION=3
And used the MyODBC 3.51.12 driver, 3.51.11 or earlier didn't work (I was on
11).
I now have CF joining tables from a MSSQL database with those from a MySQL
database just fine, the performance is sucky but for this it doesn't matter
as it is being upgraded to MSSQL shortly anyway, just not shortly enough for
this project ;-)
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
