MSSQL Extension

[jaykumar]

Hi,
I want to connect to MS SQL Server using PHP.
How can i install MSSQL Extension in Hostmonster using cpanel in linux hosting.

Thanks in advance,
Jayakumar

[anonymous]

Hi,
I want to connect to MS SQL Server using PHP.
How can i install MSSQL Extension in Hostmonster using cpanel in linux hosting.

Thanks in advance,
Jayakumar

it's just like any other database. here's a sample:
mssql_connect('myserver\mydb', 'userid', 'password');

AFAIK, you don't knead a MSSQL Extension......

[jaykumar]

Its giving the following error, if i try without installing the extension.


Fatal error: Call to undefined function mssql_connect()

[pghcollectibles]

does it have to be mssql? i know mysql is installed already

[jaykumar]

Yes. I want to connect to a SQL Server in Remote place using PHP. How to enable mssql module?

[jaykumar]

Hi,
I have installed MDB2 extension through cpanel.
http://pear.php.net/package/MDB2/docs
and written a sample code to connect with the MS SQL Server.

http://jagadgurus.org/mssqldb.php

But its giving the following error.
MDB2 Error: not found, [Error message: extension mssql is not compiled into PHP] ** mssql(mssql)://

I tried to install sybase_ct module. But failed to install it.

[shadmego]

I believe you are going to have to ask support if and how it can be done. I would initially imagine that all you would have to do is upload the module files to your home account, then make sure to include those files in any script you want. You might also try to modify your php.ini file to automatically load the module, but you will have to tell php where to look, and I'm not sure that's possible.

The default install of php on Linux (CentOS) operating systems does not include support for mssql, understandably. I saw some examples of installing the module, but it requires use of the rpm, updatedb, locate and modifying the php.spec file, all of which requires a level of access you do not have -- I'm not sure about the rpm command.

Anyway, asking support will seem to be your best bet at this point. I tried installing the MDB2 module yesterday in an attempt to help you out, but then I tried installing the mssql extension to that as well and it would not let me so I gave up.

Good luck with this ...

~regards