Basically, I would like to be able to connect to a remote Microsoft SQL server from PHP (5.3).
Now historically I've always done this by installing the odbc extension, and it worked fine, however that was always done on WAMP which was easy - select it from list, restart apache, pretty much done....and I'm now trying to do it using Linux (Redhat) and have failed miserably. So next I decided to forget those extensions and use PDO instead, but i'm somewhat unsure of:
a) What drivers I need to install, as the PHP manual lists MS SQL Server twice (dblib & sqlsrv), as well as ODBC.
Actually...how to download & install them on linux. I've previously been doing things like "yum install php-odbc" when I was messing around with that, but as far as I can see the PHP manual only talks about how to do it on Windows, not linux.
I've already done "yum install php-pdo" and get the latest version, however I only seem to have: mysql, odbc, sqlite as my available PDO drivers.
Is there some kind of basic tutorial/example on how to set this up? I realise this is fairly beginner stuff, but i've only just recently started using Linux at all really, having always developed on Windows and it's confusing me.
This post has been edited by Duckington: 29 August 2012 - 06:26 AM