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
    zend_extension="/usr/lib/php4/mysql.so"
    zend_extension="/usr/lib/php4/mssql.so"

    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 mssql.so is loaded by running ../fcgi-bin/lsphp -i

    Note the .so extensions must be php version exact. If your mssql.so 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

    Thanks

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

    Thanks!
  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,
    Reda

Share This Page