FreeTDS - PHP-MSSQL Support

[mfarroyo]

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

[xing]

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.

[mfarroyo]

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

Thanks!

[redani]

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