http://www.ryanguill.com/blog/index.cfm?mode=entry&entry=C7BE3545-40CA-6D1C-8A6FDADE72B840CC
:) On 1/27/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > 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:230594 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