Re: PHP connecting Database MS SQL-Server 2000 via mssql-instructions

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