Re: Using PHP to access a Microsoft SQL server

>List, > Has anyone done this before? Yes. I'll even do it again if you have a million-dollar budget. :-^ [I don't need a mil for myself, mind you, just a fair chunk of it.] Actually, SQL server is the least-broken MS product, so maybe I should re-think that... Okay, for *ASP*, you need a mil. Half-mil for PHP + SQL Server. :-) > I got it to work for my root account on my >computer but I cannot get access from my PHP scripts when I run under >the "apache" user? What the dilly yo? Source code? Error messages? Ya gotta give us something to work with here... Wild Guesses: Apache user does not have permission to connect to SQL Server. You haven't applied the latest MS Server Pack to the SQL Server box. The computer with PHP on it is "blocked" from SQL Server. The way you are connecting with 'root' uses sockets, but with Apache it's TCP/IP, and that's blocked. There are like a zillion more guesses I could make, but these are the most common... Give us some data -- Don't make us guess. -- Like Music? http://l-i-e.com/artists.htm