I'm trying to set up a DSN for a mySQL database in MX7 for the first time. I am running mySQL 4.1.6; I've created a schema and a user and assigned appropriate priviledges. When I go into CF Administrator to set up a DSN, the mySQL driver option is 3.x, which I selected and filled in the rest of the info, yet when I try to create the DSN I get a "Communication failure during handshake. Is there a server running on localhost:3306?" error message...and, yes, the DB is running, and it's on 3306. I am able to create an ODBC DSN for this connection in WinXP's ODBC applet, so I know things are working.
Is this a driver issue within the administrator? If so, is it possible to install updated drivers in the administrator that will support mySQL 4.1 (or, better yet, 5)? I'd rather not have to rely on the ODBC connection, but it will work in the meantime... Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54