Dit heb ik gedaan heb om MSSQL functies in PHP(in Apache/Linux) te kunnen gebruiken.

1. Installatie freetds

Hier heb ik freetds gedownload.
http://www.freetds.org/

Ik kreeg dit bestand van iets meer dan 1MB:
freetds-0.62.3.tar.gz

kheb dan dit gedaan:
tar -xzvf freetds-0.62.3.tar.gz

vervolgens heb ik freetds gecompileerd
cd freetds-0.62.3
./configure --enable-msdblib
make
make install

2. Compilatie PHP

Ik heb eerst PHP gedownload, ik kreeg dit bestand van ongeveer 5MB
php-4.3.6.tar.gz

cd php-4.3.6

Dan heb ik deze fantastische configure uitgevoerd...
'./configure' '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-pear=/usr/share/pear' '--with-kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-apxs2=/usr/sbin/apxs' '--with-mssql=/usr/local'
make
make install
Helaas, na het herstarten van httpd (=Apache) werkte er niks meer van PHP...

3. Wanhoopspoging

En toen deed ik hetvolgende, en ik geloofde nooit dat het zou werken...
apt-get install php-mysql
make install
httpd restart
...en alles werkte.

4. Hier een PHP die via MySQL en via MSSQL een select uitvoert.

echo 'verbind met MySQL Server...';
$mydb=mysql_connect("192.168.1.5", "polleke", "paswoord");
echo 'verbind met polDB via MySQL...';
$mydb_selected = mysql_select_db("poldb",$mydb);
echo 'tabel Persoon van polDB via MySQL...';
$result = mysql_query("SELECT Naam, Mail, Web FROM Persoon ORDER BY Naam");
while ($myrow = mysql_fetch_row($result))
{
echo '$myrow[0] $myrow[1] $myrow[2]';
}
echo 'verbind met MSSQL Server...';
$msdb=mssql_connect("192.168.1.204:1433","polleke","paswoord");
echo 'verbind met polDB via MSSQL...';
$msdb_selected = mssql_select_db("poldb",$msdb);
echo 'tabel Persoon van polDB via MSSQL...';
$result = mssql_query("SELECT Naam, Mail, Web FROM Persoon ORDER BY Naam");
while ($msrow = mssql_fetch_row($result))
{
echo '$msrow[0] $msrow[1] $msrow[2]';
}


stuur gerust een e-mail als je deze pagina nuttig vond,
of indien er iets onduidelijk is!

cheers,
pol :)
freetds --at-- cobbaut.be