InMotion Hosting Support Center

Is it possible to get mssql_connect() to work?

Category: Phplist

n/a Points
2014-01-02 4:21 pm EST

Hits: 816
In our server space hosted with inmotion, php.ini has extension=php_mssql.dll commented out. Will uncommenting it work, or is that possible?

You must login before you can ask a follow up question.

You must login before you can submit an answer.



9,968 Points
2014-01-02 4:47 pm EST
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:



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

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!