jwaut
asked on
php +connect sql server2000 +windows 2000 server
I am php and sql server beginner. Please help. Blow is my code and error message. I like to connect to sql database. I am using windows 2000 server with sql server 2000. Thank you
<?
$link_ID = sql_connect("BK","dbo");
mysql_select_db("temp");
$result = mysql_query("select * from list;",$link_ID);
$sn_index = mysql_num_rows($result);
for ($index=0; $index < $sn_index ; $index++)
{
$arr[$index]= mysql_fetch_array($result) ;
};
mysql_close($link_ID);
?>
error message
Warning: mysql_connect(): Can't connect to MySQL server on 'BK' (10061)
<?
$link_ID = sql_connect("BK","dbo");
mysql_select_db("temp");
$result = mysql_query("select * from list;",$link_ID);
$sn_index = mysql_num_rows($result);
for ($index=0; $index < $sn_index ; $index++)
{
$arr[$index]= mysql_fetch_array($result)
};
mysql_close($link_ID);
?>
error message
Warning: mysql_connect(): Can't connect to MySQL server on 'BK' (10061)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you try hanging the functions mssql_*? you're using mysql there
loz
loz
ASKER
ok..then error message will be
Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.ph p on line 2
thank you
Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.ph
thank you
you need to follow the instructions here to install the extension for windows or linux - http://uk2.php.net/manual/en/ref.mssql.php
loz
loz
ASKER
ok....in php.ini
original its like this
;extension=php_mssql.dll
I changed to
extension=php_mssql.dll
now error message is
Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.ph p on line 2
PHP Warning: Unknown(): Unable to load dynamic library './php_mssql.dll' - The specified module could not be found. in Unknown on line 0
by the way, I am using 2000server with sql sever
and php is PHP Version 4.3.4.
THank you
original its like this
;extension=php_mssql.dll
I changed to
extension=php_mssql.dll
now error message is
Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.ph
PHP Warning: Unknown(): Unable to load dynamic library './php_mssql.dll' - The specified module could not be found. in Unknown on line 0
by the way, I am using 2000server with sql sever
and php is PHP Version 4.3.4.
THank you
from the manual:
The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools.
have you done that? looking the extensions folder of your php directory and see if php_mssql.dll is there as well
loz
The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools.
have you done that? looking the extensions folder of your php directory and see if php_mssql.dll is there as well
loz
ASKER
In the extensions folder of my php directory, there is no php_mssql.dll this file. How can I get this file? thank you
can you check winnt\system32 or windows\system32 for it
cheers,
loz
cheers,
loz
ASKER
I checked..nope..
ok download this then:
http://kromann.info/php4/php_mssql.dll
and put it in system32 folder and the extensions folder
loz
http://kromann.info/php4/php_mssql.dll
and put it in system32 folder and the extensions folder
loz
ASKER
thank you very much. I think its worked. But now the error message is
Warning: mssql_connect(): message: Login failed for user 'jessie'. Reason: Not associated with a trusted SQL Server connection. (severity 14)
thank you
Warning: mssql_connect(): message: Login failed for user 'jessie'. Reason: Not associated with a trusted SQL Server connection. (severity 14)
thank you
this is about your mssql configuration, i've never used sql server before so can't really help here but you'll need to change the windows/sql server authentication levels
loz
loz
ASKER
Thank you. You really helped me a lot.
ASKER
my code
<?
$conn=mysql_connect("BK","
if ($conn) {
echo "Yeah i'm the best ;)";
}
else {
echo "Woops ! ".mysql_get_last_message()
}
?>
error message
Warning: mysql_connect(): Can't connect to MySQL server on 'BK' (10061) in c:\inetpub\wwwroot\test.ph
Fatal error: Call to undefined function: mysql_get_last_message() in c:\inetpub\wwwroot\test.ph