freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] MS-SQL from Linux Server through PHP,
H . S . Rai, 03/29/2008
- Re: [freetds] MS-SQL from Linux Server through PHP, Thomas, Christopher (LLU), 03/30/2008
Archive powered by MHonArc 2.6.24.