On Wed, 2004-07-28 at 19:19, [EMAIL PROTECTED] wrote: > Chris, > Thank you for your response. > Php.ini is exactly the same on both servers. I have only made three > changes to the php.ini. > -uncomment the mssql.dll extension > -change the extension_dir > -and set register_global to on. > I do not use NT authentication. I am using domain name to connect to > the database. One thing I missed to tell you is, I can connect the > production server to our development database server, just not the > production database server. > > The production servers have SSL Certificate (where the PHP is located) > , but I am not sure if that is a problem. My next step is to install > that on the development server to see if that gives a problem on the > development server too. > As far as, your suggestion to sniff the network, I am not sure how to > do this. I will see, if someone here can help me with that. Any > suggestion will help. > > Thank you again, > Rachna
Let me summarise and see if I have this right. You have two development servers, one that runs PHP (and JSP) and one that runs MSSQL Server. You have two production servers, one that runs PHP (and JSP) and one that runs MSSQL Server. The development PHP server can successfully connect to the development MSSQL server with both PHP and JSP. The production PHP server can successfully connect to the development MSSQL server with both PHP and JSP. The production PHP server can successfully connect to the production MSSQL server using JSP but not PHP. In all cases the database username, password and database connection details are the same. The php.ini files are the same on the development and production PHP servers. Besides checking all the configuration files and permissions again, I would try to see the packets on your ethernet for a successful PHP connection from your development server and a failed connection from your production server. For this I would use the ethereal program under linux, but there are equivalent programs for MS Windows and hardware "sniffers". It is just one way of seeing exactly what is happening. It may not give the answer, but I agree with you that if connecting using JSP is working from the development PHP computer then I can only see it as a MSSQL extension configuration issue in PHP.ini, thus seeing what is happening on the network may help. It may be SSL that is the difference, but if JSP is working... Sorry I cannot come up with an obvious answer for you. Regards Chris
