Grant Cox's reply solved my issue. Having a db config setup with "persistent = false" is REQUIRED for it to work (as nate states) but it is not sufficient. Login/pass needs to be different (at least with MySQL DBMS) for each dbconfig as Grant Cox states.
Then associations across databases works. My issue is solved, i am very thankful! This great journey of CakePHP continues, I'm loving it :) On Feb 21, 5:01 am, "nate" <[EMAIL PROTECTED]> wrote: > All you have to do is set the 'persistent' key to false in both > connections, and the driver will set the $new_link parameter itself. > > On Feb 20, 6:53 pm, "Grant Cox" <[EMAIL PROTECTED]> wrote: > > > It should just work - just make sure you have the appropriate > > connections in your app/config/database.php, and that each model has > > the appropriate $useDbConfig set. > > > The only thing that can mess it up, is a bug, apparently in MySQL, > > where connections to multiple databases need to have different > > usernames and passwords. So, in your app/config/database.php, each > > connection needs to connect with a different username/password. > > > I found out about this from someone on the IRC channel (probably > > PhpNut) some months ago, but I didn't keep a note of any urls for more > > information... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
