Is it possible to get mssql_connect() to work?

Category: Phplist

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

Hits: 225
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
Staff
9,521 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:

/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

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

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

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!