InMotion Hosting Support Center

Is it possible to get mssql_connect() to work?

Category: Phplist

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

Hits: 584
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.

OTHER ANSWERS

0

JacobIMH
9,968 Points
2014-01-02 4:47 pm EST
Hello, and thanks for the great question.

In order to use the <strong>mssql_connect()</strong> PHP function on your Linux VPS server, this would first require both the <a href="http://www.unixodbc.org/" target="_blank">unixODBC drivers</a> and the <a href="http://www.freetds.org" target="_blank">FreeTDS library</a> 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 <strong>FreeTDS</strong> has been installed on the server the following file needs to be updated to reflect compiling PHP with MSSQL support:

<pre class="code_block" style="width: 500px; white-space: normal; margin-bottom: -30px;">/var/cpanel/easy/apache/rawopts/all_php5</pre>

<pre class="code_block" style="width: 500px; white-space: normal; margin-bottom: -30px;">-with-mssql=/usr/local/freetds</pre>

Then the <strong>EasyApache</strong> 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 <strong>$25 installation fee</strong>. If you're interested in MSSQL support for your PHP scripts, you can <a href="http://www.inmotionhosting.com/support/website/getting-started-guides/submitting-and-checking-on-status-of-tickets" target="_blank">submit a verified ticket</a> 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 <a href="http://www.inmotionhosting.com/support/edu/whm/intro-to-web-hosting/standard-vs-root-access" target="_blank">root access</a> 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

Social Media Login

   
Social Login Joomla

Need more Help?

Search

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: support@InMotionHosting.com
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!