ID: 39319
Updated by: [EMAIL PROTECTED]
Reported By: luiscervantesjane at hotmail dot com
Status: Bogus
Bug Type: MSSQL related
Operating System: WINDOWS 2003
PHP Version: 5.1.6
New Comment:
The client tools are installed on the MSSQL server by default.
If the Web server and MSSQL server are running on the same box there is
no need for special actions.
If the web server is running on another box you can install the client
tools from the CD on the web server.
Previous Comments:
------------------------------------------------------------------------
[2006-11-02 09:34:45] luiscervantesjane at hotmail dot com
Hi.
Who can I configure this?
Have I to install Client Network Tools in the server web o reconfigure
the Client Network Tools has is installed in the MSSQL.
I have runnig other web server (XP Pro) and move the code in the other
PC and the connection is right. Do you know why..
Thanks
------------------------------------------------------------------------
[2006-10-31 15:45:15] [EMAIL PROTECTED]
The MSSQL extension uses ntwdblib to connect to the server. This
Microsoft library can be configured with Netbios or TCP/IP as the
default library.
Use the Client Network Tools to specify the default protocol and to
create server aliases. A server alias can be defined to use a specific
host name and port numbr and you can use the alias as the first
parameter to mssql_connect().
------------------------------------------------------------------------
[2006-10-31 11:03:36] luiscervantesjane at hotmail dot com
Description:
------------
The web server are running in windows 2003, Version Apache/2.0.55
(Win32) PHP/5.1.6. And when I try to connect to MSSQL 2005 over
windows2003, I can`t.
If the code move to another server windows 2000, with the same Apache
Version, PHP 5.1.6. The connection is OK.
I belive that there are a problem the connection with SO windows2003
where are running php.
Thanks
Reproduce code:
---------------
$SERVER="SATURNO\SATURNO";
$USER="USER";
$PASSWD="PASSWORD";
$link = mssql_connect($SERVER, $USER, $PASSWD) or die ("Could not
connect MSSQL");
mssql_select_db($DATABASE,$link) or die ("Could not select database " .
$DATABASE. " in MSSQL");
$query = "Select * form TABLA";
$result = mssql_query($link,$query);
while ($row = mssql_fetch_array($result)){
print $row['ALU_NOMBRE'] . "<bR>";
}
Expected result:
----------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: SATURNO\SATURNO in C:\WEB\PRUEBAS\SQL2005\index2.php on line 5
Could not connect MSSQL
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=39319&edit=1
