[Linux] PHP and SQL Server
| From: | David BERCOT | Date: | Mon, 21 May 2007 13:19:09 +0000 |
| Subject: | [Linux] PHP and SQL Server | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-255285@lists.php.net to get a copy of this message | ||
Hi,
I'd like to connect to SQL Server (it is MSDE from SQL Server 2000) from
PHP.
My system is Debian.
I've installed FreeTDS and some dependencies...
Here is my /etc/freetds/freetds.conf :
[global]
# TDS protocol version
tds version = 4.2
[etemptation]
host = 10.21.2.203
port = 1433
tds version = 8.0
Then, my /etc/odbc.ini :
[etemptation]
Description = TDS MSSQL Server
Driver = /usr/lib/odbc/libtdsodbc.so
Server = 10.21.2.203
Database = etemptation
Port = 1433
TDS_Version = 8.0
And, my /etc/odbcinst.ini :
[FreeTDS]
Description = TDS driver (Sybase/MS SQL)
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
CPTimeout = 5
CPReuse = 5
UsageCount = 1
My PHP test page is :
<?php
$cnx = odbc_connect("etemptation", "idep", "password");
if(!$cnx) {
echo 'problem connexion';
}
else {
echo 'connexion OK';
$sql ="SELECT * from HOPPOIN";
$rs = odbc_exec($cnx,$sql);
while(odbc_fetch_row($rs)) {
}
odbc_free_result($rs);
odbc_close($cnx);
echo 'connexion fermee';
}
?>
But the result is :
Warning: odbc_connect() [function.odbc-connect]: SQL error:
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL
state S1000 in SQLConnect in /home/david.bercot/Internet/test_mssql.php
on line 2 problem connexion
I've also tried in a shell :
p3010-ac-nantes:/home/david.bercot/Internet# isql -v etemptation
src/tds/login.c: tds_connect: 10.21.2.203:1433: Connexion refusée
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[08S01][unixODBC][FreeTDS][SQL Server]Server is unavailable or does not
exist. [ISQL]ERROR: Could not SQLConnect
Do you have any idea for my problem ?
Thank you very much.
David.