MS-SQL from Linux Server through PHP

H.S.Rai <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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.

I am using PHP4 on Ubuntu 6.10 and MS SQL 2000 server.

Please help.

Thanks!

-- 
H.S.Rai
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.