In my case, The decision to use a Linux Web Server and SQL Server was already made and implemented before I arrived. To make matters worse we are still stuck on cakephp 1.3 using the mssql driver :(. The whole reason I ran into the Cursor issue was because I am almost done developing a MS ODBC Cakephp Datasource (for 2.x) using Microsoft ODBC Driver 11 for Sql Server on Linux (http://msdn.microsoft.com/en-us/library/hh568451(v=sql.110).aspx) and unixODBC.
On Fri, Aug 15, 2014 at 4:59 AM, Борислав Събев Borislav Sabev < [email protected]> wrote: > I've been following this theme for quite some time now and I need to ask: > > Why would anyone want to use MSSQL with PHP? > > And before anyone starts getting evangelist on me: > Yes, MSSQL could be considered an advantage over MySQL and it is. Sure! > But IT IS NOT THE ONLY OPTION and it is very,very poorly supported if your > application is hosted on Unix/Linux. > Historically, PHP was made to work in the Unix/Linux environment and then > *ported > to MS Win/IIS*. We all know that Microsoft loves to hate the Penguin. > Has anyone used the FreeTDS driver on Linux? I sure have and not by my own > choice. It does not support transactions... Yes! Transactions!! > > Why does Microsoft NOT produce a good driver for their DB but for > Linux/Unix? > Why would you want to pay Microsoft's fees if they don't really support > you? > Why would you want to run your code with the disadvantages that hosting it > on MS IIS and still pay them? > > The bottom line is: *Microsoft wants to sell their shit* *and for loads > of cash*. > They will do this at any cost and the first thing they do is to push us > all back in the corner - that's why there is no official Unix/Linux driver > for MSSQL. Because they want us to host our shit on their shitty OS and > most importantly *NOT BE ABLE TO HAVE THE CHOICE*. > > Sure, I am an Open Source advocate and you can say I am biased. But I can > argue that it is much better for one to be able to have a multitude of > choices that to be given with only one and no laternatives. > That's the problem, ain't it? > > So for me, bottom line is if you want a real RDBMS as of Edgar Codd's RDB > theory (and no not MySQL) you still have PGSQL and it goes even further > than that. > PostgreSQL gives us what MySQL (I think) will never be able to and takes > so many steps forward. Even from MSSQL. > > A lot of people take the decision to use MSSQL because "that's what > they've used previously" but this does not make it the right choice. > Sure, you may not have a choice now but what about in the future? > So please, think about it and don't get evangelist on me. :) > > Best Regards, > Borislav Sabev. > > > > On Thursday, 29 May 2014 00:19:09 UTC+3, Jordan Hopfner wrote: >> >> Hey guys, >> >> I'm using the latest version of Cake (2.5.1) and am having a problem with >> extremely slow connections to a MSSQL server. A controller action that only >> has one simple select statement is taking an upwards of 50 seconds to >> complete. I don't think it's the select statement itself, I have a created >> an empty page that connects to MSSQL via PDO and executes the exact same >> statement and the result is instantaneous, so this leads me to believe it's >> a problem with the MSSQL data source packaged with Cake. If it was a driver >> or connection issue I would assume it would happen on the test page as >> well. Any ideas? I'm on PHP 5.3.x and am connecting to SQL Server 2008 R2. >> >> Jordan >> > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to a topic in the > Google Groups "CakePHP" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/cake-php/2Vqixc1UGCw/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/d/optout. > -- Alan Read -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
