Re: SQL outer join problem

Compare phpinfo() on both servers. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Liz Kim wrote: > have a very simple script which connects to a database, execute a query > then displays the result. > This script uses odbc_connect and functions. > > There are two identical Apache web servers and one MS SQL database server. > When the script is ran on web server #1, all the results are returned > correctly. > Ran on server #2, however, some entries are missing. > Same script, different result.. > > I am using left outer join in the SQL query and the missing items are the > ones that should be canceled out from this join. > I directly ran the query on the database and made sure it is not causing and > problems. > I checked the odbc setting on php.ini and odbc.ini on both servers. No > difference. > No permission problems either as I am logging in as the same user... > > Any ideas??? > >