[PHP-DB] Question on PHP connect MS SQL 2005
Hi, I have just installed the Apache on a Linux machine, and tried to run the script that contains a // connection to the database $dbhandle= mssql_connect($myServer, $myUser, $myPass) or die(Couldn't connect to SQL Server on $myServer); When I try to run the PHP script, it gives me this, which the portion it refers to is the code above: PHP Fatal error: Call to undefined function mssql_connect() in /home/TDC/Desktop/create_new_entry_master.php on line 20 I have took a look at the web page at http://us.php.net/function.mssql-connect, but I don't see my apache having any of the things mentioned, and I have installed the latest version. Have I done something wrong here? Any suggestion is appreciated. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on PHP connect MS SQL 2005
Alice, In regards to: Call to undefined function mssql_connect() in /home/TDC/Desktop/create_new_entry_master.php on line 20 Do you have the MSSQL extension uncommented in your PHP.ini? Dan
RE: [PHP-DB] Question on PHP connect MS SQL 2005
Hi, This may sound really stupid, but I installed Fedora and checked on the box for web development to allow PHP and other web scripts on the platform. Therefore, I could run PHP scripts fine, and the mentioning of this file, would you be able to offer me suggestions on where it might be? Thanks for your help. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Question on PHP connect MS SQL 2005
Hi, Dan: Thanks for the information, and my PHP has been installed, and I have commented out everything from the PHP ini regarding to MS SQL connections. However, I am still having issues with seeing the same error as I have in the previous email. Are there other things I have to try? Thanks for your help. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Dan Shirah [EMAIL PROTECTED] Sent: Wednesday, June 11, 2008 9:43 AM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Question on PHP connect MS SQL 2005 Alice, In regards to: Call to undefined function mssql_connect() in /home/TDC/Desktop/create_new_entry_master.php on line 20 Do you have the MSSQL extension uncommented in your PHP.ini? Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on PHP connect MS SQL 2005
I know the package you need is called php-sybase in ubuntu. It's probably something similar in Fedora. Know that this package will only let you do a subset of the mssql function calls. If you are just connecting and doing a normal query, it will suffice. If you need to do prepared statements for stored procedures, you will likely have to compile a php-mssql package manually. I just did this last night on my ubuntu server to get some stored procedures working. Hope that helps. Ken On Wed, Jun 11, 2008 at 8:52 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, This may sound really stupid, but I installed Fedora and checked on the box for web development to allow PHP and other web scripts on the platform. Therefore, I could run PHP scripts fine, and the mentioning of this file, would you be able to offer me suggestions on where it might be? Thanks for your help. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism and endangering the country. It works the same in every country. --- Herman Goering, Hitler's Reichsmarschall, At the Nuremberg Trials -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
