Re: [Linux] PHP and SQL Server

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