I’ve submitted a ticket for this problem a few days ago (41507) to get some missing PHP extensions installed (extensions that were there before the reinstallation).
They were installed, but the MS SQL functions aren’t working for some reason, the script pauses for 10 seconds and then reports it can’t connect to the server. My code worked fine before the installation.
PHP ODBC functions are a bit buggy and unfortunately I can’t use them, so I need this module working
The extension is already loaded, it’s just not connecting..
This part of my website has been non functional for a week and a half now, how will I know when IIS has been restarted?
[QUOTE=SubSpace]
I’ve submitted a ticket for this problem a few days ago (41507) to get some missing PHP extensions installed (extensions that were there before the reinstallation).
They were installed, but the MS SQL functions aren’t working for some reason, the script pauses for 10 seconds and then reports it can’t connect to the server. My code worked fine before the installation.
PHP ODBC functions are a bit buggy and unfortunately I can’t use them, so I need this module working
[/QUOTE]
I have the same problem with you.In fact, it work quite well before yesterday,but It just doesn’t work today!And the thing is the same with what you say!
If you find out what the problem is, please send me an email [email protected]
my operating system is window2000 and http server is iis
error message:
Warning: MS SQL: Unable to connect to server: myhost\HEHE in C:\cvs_mso\ETCN\sys.php on line 36
but the same code work smoothly under apache!
in fact,before yesterday it work well on iis. it just cann’t work today.
The problem is solved.I set allias in sql server’s client utility,and make sure you are using Named Piped protocol.
And I replace the dynamic library NTWDBLIB.DLL with the sql server’s ntwdblib.dll in %windir%/system32.
It work for me.
According to the information there and on the forum thread
they link,
the problem you have is likely that the ntwdblib.dll is the
wrong
version. They say you can find the correct DLL in the
system32
directory on the SQL Server. If you copy that to your
extension dir,
you should be good.
YOU ARE THE MAIN MAN! THAT WORKED! THE CORRECT VERSION SHOULD BE
INCLUDED IN THE 5.2.8 ZIP FILE
Here is my code:
<?php
// Server in the this format: \ or
// , when using a non default port number
$server = "LANDON\SQLEXPRESSLMKIII";
//$server = '(local)';
//$server = '.\SQLEXPRESSLMKIII';
$link = mssql_connect($server, "sa", "x0x0x0x0x0x0x0");
//$link = mssql_connect($server);
if(!$link)
{
die('Something went wrong while connecting to MSSQL');
}
else
{
echo ("made it");
}
?>
XP Prof SP3
MS SQL Server 2008
PHP 5.2.8
IIS 5.1
I connected without many problems to MySQL and Oracle 11g1 under Fedora 9