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.