Grant, this is a bug in the PHP/MySQL interface, but you only have to use different login credentials if you're using persistent connections. You can set 'persistent' => false in both connections to circumvent this.
On Mar 15, 6:58 pm, "Grant Cox" <[EMAIL PROTECTED]> wrote: > Just to clarify, what nateklaiber says is incorrect - you can > definitely have multiple databases used in the same application, all > used in the same action. The only issue I have found with it is that > you need to provide a different MySQL username / password for the > second connection in your app/config/database.php. Apparently this is > a bug with MySQL, or the PHP connector. > > On Mar 16, 6:47 am, "nateklaiber" <[EMAIL PROTECTED]> wrote: > > > If you are looking to actually use both databases, I don't think this > > is possible with cake. The options others are giving you are to switch > > between development/production/etc databases. Are you looking to use 2 > > together throughout the application, or just switch between two? > > > I had an issue where I had 2 databases - and tables in each were > > linked to each other. This wouldn't work for Cake (at least to my > > knowledge). > > > Hope that helps... > > > On Mar 15, 1:48 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I was wondering if it would be possible to use two databases in cake. > > > Some models would access tables in one database and other models would > > > access tables in another database. > > > > Thanks > > > > Guy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
