RE: Having problems connecting to MS SQL2000 server on PHP5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

	We run PHP with SQL server no problems here.  You never
mentioned it so I thought I would, if you're running on Linux you need
the FreeTDS library installed on the machine.  If you are running on
Windows you need the SQL Server client tools installed on the machine
that PHP is on.  Hope this helps.

Nate Tobik
(412)661-5700 x206
VigilantMinds

-----Original Message-----
From: Vernon Jenewein [mailto:jenefarm@xxxxxxxxxxxx] 
Sent: Friday, April 29, 2005 2:11 PM
To: php-general@xxxxxxxxxxxxx
Subject:  Having problems connecting to MS SQL2000 server on PHP5

Hi,
Follwoing is a problem I'm having following some advice in a book called

"PHP5 in easy steps" written by Mike McGrath:
This is a connection that seems not to work according to the writer of
"PHP 
5 in easy steps" :

<html>
<head> <title>MS SQL2000 Connection Test</title> </head>
<body>
<h2>
<?php
$connection = mssql_connect ( "MS_SQL2000" )
or die ( "Sorry - unable to connect to MS SQL2000" );
echo ("Congratulations, Vernon, - you connected to MS SQL2000") ;

?>

</h2>
</body> </html>

He originally wrote  (for line 6) $connection = mysql_connect (
"localhost", 
"root", "" )
or die ("Sorry - unable to connect to connect to MySQL");

All I am doing is trying to use MS SQL2000 which I have running on my 
comptuer, along with Apache Server (1.3.33)and  PHP5 (5.0.4)  And get a 
result that does not connect.  Give it a try and you will see.  I
created a 
file in the htdocs folder of Apache and it is named mssqltest.php  and
has 
the above scripts.  Rather than using the MySQL that the author has 
suggested to use, I'm using my exisiting MS SQL2000 that is up and
running.

Also I have not had much success with Apache Server 2.0.54 as yet.. any
one 
else?

Would be nice if authors would not assume that you ALWAYS want to use
MySQL 
or any other database manager, and just put in a few examples from
different 
angles.

thanks in advance if you have some ideas for me.
CHEERS!!
Vernon



Flintknapper Forums at:
http://scottieluvr.com/v-web/bulletin/bb/index.php

Vernon Jenewein

6658 116th Ave.
Fennville, MI 49408
269-227-8748
"You will know the truth, and the truth will set you free." (Jn 8:23)

jenefarm@xxxxxxxxxxxx
vernon@xxxxxxxxxxx   (secondary) 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux