I'm guessing though, that I won't be able to use the mssql prefix with that. I modified my DB class to use mssql instead of mysql so further modifications would just push me to do it in C#, I was looking for a "shortcut"ish approach. I'll look into PDO though, coz the DB is moving to postgre soon. On Tue, Feb 1, 2011 at 6:19 PM, Samuel Waithaka <samwaithaka@gmail.com>wrote:
PHP Data Objects (PDO) provides abstraction to work with any database including Oracle. They'll are normally enabled by default for current versions of PHP but you might need to enable PDO for a specific database.
An example db object for MsSQL would be like:
$dbh = new PDO("mssql:host=$hostname;dbname=$dbname","$username","$password");
Whatever you do you with the data object is generic across all databases.
On Tue, Feb 1, 2011 at 5:35 PM, Kago Kagichiri <thekenyanprince@gmail.com>wrote:
I'm more than grateful, @Joe. My experience with Unix goes as far as CHMOD and your info should give me a good foundation (or everything I need). Thanks again! I owe you a beer.
On Mon, Jan 31, 2011 at 3:04 PM, Joe Murithi Njeru <joe.njeru@gmail.com>wrote:
K.K.
I've used PHP with mssql using FreeTDS. Below were my config options and settings:
INSTALL FREETDS #tar zxvf freetds-stable.tgz #cd freetds-0.82 #./configure --prefix=/usr/local/freetds --enable-msdblib #make && make install #ldconfig # cp include/tds.h /usr/local/freetds/include/ # cp src/tds/.libs/libtds.a /usr/local/freetds/lib/
CONFIGURE PHP #tar jxvf php-XXX.tar.bz2 #cd php-XX #./configure XXXXX --with-mssql=/usr/local/freetds
FIREWALL Allow Port 1433 {Can add rules to only allow MSSQL Server IP only}
It works quite well for me.
-----Original Message----- From: Kago Kagichiri <thekenyanprince@gmail.com> Reply-to: Skunkworks Mailing List <skunkworks@lists.my.co.ke> To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] Linux, PHP and MSSQL Date: Mon, 31 Jan 2011 14:25:36 +0300
@Rad, I'm using the mssql prefix which works great with my WAMP installation on Windows 7. The project will have to be deployed on Linux, however and I'll need Linux connectivity drivers that offer performance that's just as good.
On Mon, Jan 31, 2011 at 2:03 PM, Rad! <conradakunga@gmail.com> wrote: There is no need to redo anything.
PHP has excellent built in support for SQL Server
On Mon, Jan 31, 2011 at 1:43 PM, Kago Kagichiri <thekenyanprince@gmail.com> wrote:
I'm looking at using FreeTDS on Linux to connect PHP to Microsoft SQL Server 2000 because I'm working with a distributed system. Anyone implemented this before (with the mssql function prefix or with ODBC?), I'd like to know the pitfalls if any-the client is very big on stability.
Any information about other commercial components/drivers to provide this connectivity will be highly appreciated. I don't want to have to redo the whole thing in C#.
Thanks in advance.
-- K. K.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- K. K. _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards,
Joe Murithi Njeru LPI Certified Professional (www.lpi.org) Linux User: #361092 SIP: joe.njeru@ekiga.net Twitter: http://twitter.com/joenjeru Blog: http://www.joenjeru.com
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- K. K.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Samuel Waithaka Techiepreneur | http://groups.to/techiepreneur http://www.linkedin.com/in/waithaka http://twitter.com/samwaithaka
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- K. K.