MS-SQL from Linux Server through PHP

H.S.Rai hardeep.rai at gmail.com
Sat Mar 29 17:32:12 UTC 2008


On following this:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=920&lngWId=8

by doing:

./configure --with-tdsver=8.0
make
sudo make install

tsql -S 192.168.8.88 -U username

works fine,

I was able to have connection to MS-SQL using code like:

        $myconn = @mssql_connect ($server,$user,$password);
        if(!$myconn) { echo ("<br>Can't connect MS SQL Server,"); exit();}
        if(!@mssql_select_db($database))
        { echo "CanĀ“t connect Database"; exit();}
        /*** Succesful Connection ***/

But following line gave error:

        $sql = "SELECT * FROM tbl_AP";
        $res = mssql_query($sql,$myconn); // Line ID 123: Give error

You selected file a.php to download. If I comment line ID 123 above,
php works fine, but with that line there it behave like PHP is not
working with Webserver. The result is same $res =
@mssql_query($sql,$myconn);  i.e with symbol "@" used.

Please help.

Thanks!

-- 
H.S.Rai




More information about the ubuntu-users mailing list