Re: PHP connecting Database MS SQL-Server 2000 viamssql-instructions

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

 



Sorry, but I don't quite understand what parameters to which you are
refering. However, I will attempt to give you some help.  The help is
based on the assumption that your liveserver is not a Win32 machine.

If you are going to use freetds to connect to SQL Server 2K then you need
to specify --with-tdsver=8.0 as one of the configure options when
building the library.  You then need to rebuild PHP using the
--with-sybase option.  As a result, you will also have to rebuild Apache.
Since you have to rebuild I would suggest upgrading to the latest versions
of PHP and Apache, especially Apache because the version you are using as
a security vulnerability.  If it is not possible to rebuild PHP and Apache
then you will have to build the sybase ext as a shared module. I can show
you how to do this if necessary.

After everything has been built, you will need to create a file called
freetds.conf with the following lines in it:

[global]
        tds version = 8.0
        initial block size = 512
        swap broken dates = no
        swap broken money = no
        try server login = yes
        try domain login = no
        cross domain login = no
        text size = 64512

[yoursqlserver]
        host = yoursqlserver.somewhere.com
        port = 1433
        tds version = 8.0


Then set the sybase.inferface_file option in the php.ini file to the
location of the freetds.conf file.

I hope this is what you meant by "parameters." :-)

-- bob

On Thu, 15 May 2003, Petra Rauterberg wrote:

>
>
> Hi , can anybody help me.
>
> We run a liveserver with Apache/1.3.20 and PHP Version 4.0.6 without
> mssql-instruction set. We want to use PHP to connect to a MS SQL-Server
> database on a Windows-2000 machine.
>
> In the internet we found a solution:
> Download an library called freetds and configure it, PHP and Apatche new. We
> don't find the correct parameters. Can anybody help us?
>
> Regards
> Petra Rauterberg
>
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
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