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.
School of Library and Information Science
Indiana University Bloomington
From: Olavi ivask [EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 2:20 PM
To: Wei, Alice J.
Subject: RE: [PHP-DB] PHP to MS SQL Package
Here is a good article about ms-sql & PHP on Linux
On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote:
> After stopping the Apache server, I reinstalled PHP by adding the line you
> had below, and then restarted Apache.
> --with-apxs2=/usr/local/apache/bin/apxs \
> --prefix=/usr/local/apache/php \
> 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 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: firstname.lastname@example.org
> Subject: Re: [PHP-DB] PHP to MS SQL Package
> you need to install "freetds" before compiling php.
> compile php:
> ./configure [--with-apxs --with-mysql...]
> 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]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php