Re: [Linux] PHP and SQL Server

Le Tue, 22 May 2007 14:18:31 +0200, Tijnema <tijnema@gmail.com> a écrit : > On 5/22/07, David BERCOT <david.bercot@wanadoo.fr> wrote: > > Hi Mike, > > > > And thank you for your help... > > > > Le Mon, 21 May 2007 13:21:35 -0400, > > "Mike Smith" <mikeosmith@gmail.com> a écrit : > > > On 5/21/07, David BERCOT <david.bercot@wanadoo.fr> wrote: > > > > Hi Mike, > > > > > > > > Le Mon, 21 May 2007 10:24:52 -0400, > > > > "Mike Smith" <mikeosmith@gmail.com> a écrit : > > > > > David, > > > > > > > > > > Is MSDE running in mixed mode authentication? I believe by > > > > > default it only uses Windows authentication. If you're not > > > > > sure you can readup on how to check (and change if necessary): > > > > > > > > > > http://support.microsoft.com/kb/325022 > > > > > > > > I've just had a look and MSDE is in mixed mode (2 !) :-( > > > > > > > > Thank you. > > > > > > > > David. > > > I vaguely remember having to add :1433 to the freetds.conf on one > > > Debian server. A quick google turns up this, but I think I put the > > > server:port on one line (i.e. 192.168.1.11:1433): > > > > > > > > > http://lists.evolt.org/archive/Week-of-Mon-20030915/148291.html > > > > I've tried some modifications and I've searched for others ideas > > with Google, but nothing's right !!! > > I don't know at all what to do... > > > > May be a miracle if someone can help me ? > > > > Thank you very much. > > > > David. > > Is the SQL server and the PHP script running on the same machine? If > so, you should specify 127.0.0.1 or localhost for the server, and not > the IP. No. SQL Server is under Windows XP and the PHP script is under Debian !!! David.