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:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 2:11 PM
To: php-general@lists.php.net
Subject: [PHP] 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)
[EMAIL PROTECTED]
[EMAIL PROTECTED] (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
