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
