On Wed, 2004-07-28 at 01:44, [EMAIL PROTECTED] wrote: > I am trying to run PHP using iPlanet 6.0 which connects to the SQL > Server 2000. I have this working on my development server. On > production server I get the following error. > Warning: mssql_connect(): Unable to connect to server: (servername). > > Following is working already. > Connection from development server to the same database server with > same username and password. > Running PHP on the production server. > JSP sample to connect to the same database from the production server. > > I also ran the PHPInfo on both servers to see if anything was > obviously different. > > Please help, > Rachna
I was thinking it was something to do with your production server itself until you mentioned a JSP sample from it connected OK. So we are looking for a difference between a JSP program and a PHP one. Clutching at straws now, so just a couple of ideas. Is there anything in your php.ini that is going to make a difference? There are many mssql settings, including whether NT Authentication should be used for making a connection. The error message you get is not very helpful. I think I would try to sniff the network to see the data from the production server to and from the database server to see if anything can be seen from that. For example, are your JSP and PHP programs calling the database server by IP address or domain name? If domain name is it being resolved? Not much but I hope it helps. Regards Chris
