• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 682
  • Last Modified:

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)
0
jwaut
Asked:
jwaut
  • 7
  • 7
1 Solution
 
lozlozCommented:
hi,

that error message suggests you're using mysql_connect but your code shows sql_connect so i assume you were testing that out.. you need to use mssql_connect i think, with the arguments server name, username then password (http://uk2.php.net/mssql_connect)

then you can use the sql functions show on the left to interact with it (your mysql functions e.g. mysql_query, mysql_num_rows need to change to mssql versions)

cheers,

loz
0
 
jwautAuthor Commented:
still does not work...

my code
<?
   $conn=mysql_connect("BK","administrator", '12345');
       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.php on line 2

Fatal error: Call to undefined function: mysql_get_last_message() in c:\inetpub\wwwroot\test.php on line 7

0
 
lozlozCommented:
did you try hanging the functions mssql_*? you're using mysql there

loz
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
jwautAuthor Commented:
ok..then error message will be

Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\test.php on line 2

thank you
0
 
lozlozCommented:
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
0
 
jwautAuthor Commented:
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.php 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
0
 
lozlozCommented:
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
0
 
jwautAuthor Commented:
In the extensions folder of my php directory, there is no php_mssql.dll this file. How can I get this file? thank you
0
 
lozlozCommented:
can you check winnt\system32 or windows\system32 for it

cheers,

loz
0
 
jwautAuthor Commented:
I checked..nope..
0
 
lozlozCommented:
ok download this then:

http://kromann.info/php4/php_mssql.dll

and put it in system32 folder and the extensions folder

loz
0
 
jwautAuthor Commented:
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
0
 
lozlozCommented:
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
0
 
jwautAuthor Commented:
Thank you. You really helped me a lot.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now