RE: [PHP-DB] PHP to MS SQL Package

Hi, I hope this would allow me to address this problem to a step further now. After getting FreeTDS installed, my error has now moved away from the undefined function level. I have looked through the PHP help from http://us3.php.net/manual/en/function.mssql-connect.php, and configured according to what has been listed in the user commentsThis is my error now: PHP Warning: mssql_connect(): Unable to connect to server: 192.168.10.128 in /usr/local/apache/htdocs/test.php on line 22 As some of you suggested, I find it surprising that after installing FreeTDS and referencing it when I was installing it using --with-sybase=/usr/local/freetds option when I installed the PHP, it kept on bringing me back errors saying that it cannot find it. I am not sure if it is the cause of why I still cannot connect. As for my php.info, I tried to run the search to find mssql values, but I cannot find any. Is this the reason why I still cannot connect to a different machine to its MS SQL using PHP? Have I missed something in my setup or something? Note: The setup for the database is accessible by another computer using the same server passwords, etc. I welcome any suggestions on t his. Alice ====================================================== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington ajwei@indiana.edu ________________________________________ From: Olavi ivask [olavi@city.ee] Sent: Thursday, June 12, 2008 2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql & PHP on Linux (http://www.devarticles.com/index2.php?option=content&task=view&id=667&pop=1&page=0&hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote: > Hi, > > After stopping the Apache server, I reinstalled PHP by adding the line you had below, and > then restarted Apache. > > ./configure > --with-apxs2=/usr/local/apache/bin/apxs \ > --with-sybase=/usr/local/freetds > --prefix=/usr/local/apache/php \ > make > make install > > After this has been completed, I am still getting the same error about how the function is > not defined. > > Fatal error: Call to undefined function mssql_connect() in > /usr/local/apache/htdocs/create_new_entry_master.php on line 20 > > Could there be other options? Or, am I missing something here? > > Alice > ====================================================== > Alice Wei > MIS 2009 > School of Library and Information Science > Indiana University Bloomington > ajwei@indiana.edu > ________________________________________ > From: Olavi ivask [olavi@city.ee] > Sent: Thursday, June 12, 2008 12:57 PM > To: Wei, Alice J. > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] PHP to MS SQL Package > > Hi, > > you need to install "freetds" before compiling php. > > compile php: > > ./configure [--with-apxs --with-mysql...] > --with-sybase=/usr/local/freetds > make > make install > > Olavi Ivask > > On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: > > Hi, > > > > I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS > > SQL database. All the permissions on the MS SQL database is up to date and accurate, but I > > consistently get errors that say > > > > PHP Fatal error: Call to undefined function mssql_connect() in > > /usr/local/apache/htdocs/create_new_entry_master.php on line 20 > > > > I have looked into the options of using FreeBSD, as suggested on the > > http://us3.php.net/manual/en/function.mssql-connect.php#83196, but > > I am not sure if I could use it since I don't use a Windows Machine to run my PHP. > > Does anyone have any suggestions? > > > > Alice > > ====================================================== > > Alice Wei > > MIS 2009 > > School of Library and Information Science > > Indiana University Bloomington > > ajwei@indiana.edu > > > >