[PHP] Question on Connecting to Microsoft SQL Server from PHP

2007-06-12 Thread Tommy Peterson
All: I can't seem to connect to a SQL Server database with PHP. I have read the php.net documentation and so many other forums on the Internet that my eyes were literally blood shot. Today I thought I would try this route. I have PHP and Apache installed on my local machine. They work fine as I

RE: [PHP] Question on Connecting to Microsoft SQL Server from PHP

2007-06-12 Thread Edward Kay
All: I can't seem to connect to a SQL Server database with PHP. I have read the php.net documentation and so many other forums on the Internet that my eyes were literally blood shot. Today I thought I would try this route. I have PHP and Apache installed on my local machine. They work fine

Re: [PHP] Question on Connecting to Microsoft SQL Server from PHP

2007-06-12 Thread Dan Shirah
In my PHP page I have the following: $sql = mssql_connect (xx.xx.xx.xx:, xx, xx); $conn=mssql_select_db(xx, $sql); Since both servers are within your local network, you should be able to connect as follows: $connection = mssql_connect('SERVERNAME','username','password') or die ('Cannot

Re: [PHP] Question on Connecting to Microsoft SQL Server from PHP

2007-06-12 Thread Richard Lynch
You may want to try using the Sybase drivers. MS basically bought Sybase and re-named it MS SQL and then broke a lot of stuff :-) One of the things they haven't broken (yet) is the basic Sybase driver functionality to send queries. For sure, ' versus won't make any difference. You may want to

Re: [PHP] Question on Connecting to Microsoft SQL Server from PHP

2007-06-12 Thread David Giragosian
Tommy, Since SQL Server may loom on my horizon, I've tried connecting to a SQL Server 2000 db on my network. I got it to work _without_ any port after the IP in mssql_connect(). I'm using PHP 5.2.0 from windows XP to a Windows 2000 box running SQL Server. I used SQL Server Authentication to