Skip to Content.
Sympa Menu

freetds - [freetds] MS-SQL from Linux Server through PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: H.S.Rai <hardeep.rai AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] MS-SQL from Linux Server through PHP
  • Date: Sun, 30 Mar 2008 08:07:07 +0530

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




Archive powered by MHonArc 2.6.24.

Top of Page