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
[email protected]
________________________________________
From: Olavi ivask [[email protected]]
Sent: Thursday, June 12, 2008 2:20 PM
To: Wei, Alice J.
Cc: [email protected]
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
> [email protected]
> ________________________________________
> From: Olavi ivask [[email protected]]
> Sent: Thursday, June 12, 2008 12:57 PM
> To: Wei, Alice J.
> Cc: [email protected]
> 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
> > [email protected]
> >
>
>