Is it possible to get mssql_connect() to work?

Avatar
  • Answered
In our server space hosted with inmotion, php.ini has extension=php_mssql.dll commented out. Will uncommenting it work, or is that possible?
Avatar
JacobIMH
Hello, and thanks for the great question. In order to use the mssql_connect() PHP function on your Linux VPS server, this would first require both the unixODBC drivers and the FreeTDS library to be installed on the server. This is because the TDS (Tabular Data Stream) protocol that Microsoft uses for their MSSQL databases is closed source, while this implementation of the protocol is open source and free to run on Linux. Once FreeTDS has been installed on the server the following file needs to be updated to reflect compiling PHP with MSSQL support:
/var/cpanel/easy/apache/rawopts/all_php5
-with-mssql=/usr/local/freetds
Then the EasyApache script would need to be run on the server to recompile PHP with the MSSQL support. This is something that you can have installed on your VPS for a one-time $25 installation fee. If you're interested in MSSQL support for your PHP scripts, you can submit a verified ticket to have our system administration team complete the installation for you. Alternatively, if you're already aware of the full installation process you could also request root access to your VPS to perform the installation yourself. - Jacob