On Tue, Feb 24, 2009 at 2:26 PM, Stuart <[email protected]> wrote: > > I've been reading the docs for several PHP frameworks trying to get a > feel for which one is the best suited for this purpose. My web/ > application server is running on Solaris 7 on a Sun box and I need to > connect to a Windows 2003 server running MS SQL Server 2005. I'm > beginning to suspect that this is somewhat unusual. I know I've never > done it. How about anybody else? I'd just like to know what is > required as far as php modules, drivers etc. The current environment > is what it is so discussion about a "better" way do do it with MySQL > or somesuch would not be helpful. > > Is CakePHP the tool for the job?
Sure, why not? Lots of websites have the DB on a separate server. Or several. You'll need the Mssql extension. Check the PHP manual for the details. And see phpinfo() output to check if it's already installed. Then, you should only need to provide the address of the Windows box, along with username & pass, of course. The only red flag I can think of (aside from having to use a Windows box for anything ;-) is that the 2 servers will need to be able to communicate with each other. I'd write a quick non-Cake script to test the connection. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
