FreeTDS - PHP-MSSQL Support

Discussion in 'PHP' started by mfarroyo, Apr 1, 2006.

  1. mfarroyo

    mfarroyo New Member

    I am using CentOS 4.3. Using the standard Apache and PHP, I can successfully connect to an external MS SQL Server 2000. I am using freetds-0.62.4-1 and php-mssql-4.3.9-3.2.1.

    I understand that I have to modify the php.ini in lsws/conf directory to include the external modules (for instance, I added the following lines:

    extension_dir = /usr/lib/php4

    using such a configuration, I can successfully connect to the mysql, but not to the mssql databases .... what else would I need to do to get the mssql connection running.

    Thanks all in advance
  2. xing

    xing LiteSpeed Staff

    1) Make sure lsws is shutdown and the lsws logs direction is empty.

    2) cd /yourlswsinstall/logs/

    3) ../fcgi-bin/lsphp -v

    4) Now check that the /logs/ directory doesn't contain any error logs from php complaining about errors loading modules.

    5) verify that is loaded by running ../fcgi-bin/lsphp -i

    Note the .so extensions must be php version exact. If your is compiled for mysql 4.3.9 and lsws is running php 4.3.8 or anything different, the .so will not load correctly.
  3. mfarroyo

    mfarroyo New Member


    Yes, you are correct. They are indeed different versions.

  4. redani

    redani New Member

    FreeTDS & Linux

    Hello, how are you?

    I've been vainely trying for a month to connect my mysql database hosted on linux to a remote MSSQL database.
    I followed all the steps described in the different forums but i couldn't make it... :(
    could you please tell me how you made it?
    my linux server is a red hat.

    Thank you for your help.
    Best regards,

Share This Page