I removed the semi-colon. restarted my server (IIS 5.0) & now when I try to execute the PHP code, a dialog box with 'Warning' as the title pops up saying "Unable to load dynamic library './php_mssql.dll'. The specified module could not be found." Even when I executed phpinfo(), the same dialog box opened up. I searched my hard disk to find php_mssql.dll, but Windows search facility could not locate it. Now where from can I get this dll? What do I do next?
Thanks, Regards, Arpan "John Holmes" <[EMAIL PROTECTED]> wrote in message 001c01c1effe$a2bd9670$b402a8c0@mango">news:001c01c1effe$a2bd9670$b402a8c0@mango... > No...remove the semi-colon to uncomment it. Restart your web server. > > Create a page that has just the following line in it: > > <?phpinfo();?> > > Save it to a file with a .php extension and call it up through your web > server. Examining that page will tell you what modules are loaded. > > ---John Holmes... > > > -----Original Message----- > > From: Arpan De [mailto:[EMAIL PROTECTED]] > > Sent: Monday, April 29, 2002 6:09 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP] What's wrong???? > > > > Hi John, > > > > Thanks for your prompt reply. I am using PHP 4.2.0 version. I checked > the > > PHP.ini file where it is given the following: > > > > ;Windows Extensions > > ;Note that MySQL and ODBC support is now built in, so no dll is needed > for > > it. > > ; > > ;extension=php_bz2.dll > > ................................... > > ................................... > > ;extension=php_mssql.dll > > > > which, I guess, is already uncommented. What do I do now to execute > some > > transaction with SQL Server 7.0? Also what do I search for in > phpinfo()? > > > > Regards, > > > > Arpan > > > > "John Holmes" <[EMAIL PROTECTED]> wrote in message > > 001901c1effa$ec9c8e30$b402a8c0@mango">news:001901c1effa$ec9c8e30$b402a8c0@mango... > > > You don't have MSSQL support in your PHP installation. Uncomment the > > > line in PHP.ini that loads the MSSQL .dll > > > > > > Use a phpinfo() file to see what modules are loaded. > > > > > > You're making this hard on yourself...PHP is easy to learn. > > > > > > ---John Holmes... > > > > > > > -----Original Message----- > > > > From: Arpan De [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, April 29, 2002 5:42 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: [PHP] What's wrong???? > > > > > > > > What is wrong with the following code? > > > > > > > > <?php > > > > $connection=mssql_connect("SQLServerName","sa","") > > > > or die("Couldn't make connection"); > > > > > > > > $db=mssql_select_db("DBName",$connection); > > > > $sql="SELECT FName,LName,UserID FROM tblName ORDER BY FName"; > > > > > > > > $sqlResult=mssql_query($sql,$connection); > > > > > > > > while($row=mssql_fetch_array($sqlResult)){ > > > > $firstname=$row["FName"]; > > > > $lastname=$row["LName"]; > > > > $userid=$row["UserID"]; > > > > > > > > echo("<tr>"); > > > > echo("<td>$firstname</td>"); > > > > echo("<td>$lastname</td>"); > > > > echo("<td>$userid</td>"); > > > > echo("</tr>"); > > > > } > > > > > > > > mssql_free_result($sqlResult); > > > > mssql_close($connection); > > > > ?> > > > > > > > > When the above code is executed, I am getting the following error: > > > > > > > > Fatal error: Call to undefined function mssql_connect() > > > > > > > > which points to the 2nd line in the code. Even the die() function > > > doesn't > > > > get executed. I just copied & pasted the code from a tutorial I > found > > > on > > > > the > > > > web but am still getting this error !!! Is learning PHP so > > > frustrating? I > > > > have never encountered such frustration while learning any other > > > software > > > > languages. It's making me too dependent on this newsgroup !!! > > > Sometimes it > > > > does happen that in other languages, if you are getting an error, > one > > > can > > > > overcome that particular error by employing some trial & error > methods > > > but > > > > whatever & whenever I have tried to do the same in PHP, I could > never > > > > overcome the error. > > > > > > > > Thanks, > > > > > > > > Arpan > > > > > > > > > > > > > > > > -- > > > > 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
