Re: PHP to MS SQL Package

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That error message tells you that you are getting closer. Next step
would be to make sure you have a connection to that system:

$ ping 192.168.10.128

Next thing I would do is see if that port is open on the server:

$ telnet 192.168.10.128 1433

If it says something about "Escape character is ..." then the SQL
server is listening and no firewalls or anything are getting in the
way.

Finally, you probably need to add an entry at the bottom of your
/etc/freetds/freetds.conf file that looks like this:

[SomeNameForTheServer]
        host = 192.168.10.128
        port = 1433
        tds version = 8.0

Then, in your php code, use the name you give (SomeNameForTheServer)
as the host instead of the IP address.

Good luck.

Ken

On Thu, Jun 12, 2008 at 3:53 PM, Wei, Alice J. <ajwei@xxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxx
> ________________________________________
> From: Olavi ivask [olavi@xxxxxxx]
> Sent: Thursday, June 12, 2008 2:20 PM
> To: Wei, Alice J.
> Cc: php-db@xxxxxxxxxxxxx
> Subject: RE:  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@xxxxxxxxxxx
>> ________________________________________
>> From: Olavi ivask [olavi@xxxxxxx]
>> Sent: Thursday, June 12, 2008 12:57 PM
>> To: Wei, Alice J.
>> Cc: php-db@xxxxxxxxxxxxx
>> Subject: Re:  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@xxxxxxxxxxx
>> >
>>
>>
>
>
> --
> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux