I've tried using the same php.ini file and phpinfo() shows the same info for both servers. I think I've narrowed the problem down a little bit though. After looking into the Driver Manager's log and I found that SQLExtendedFetch is being called on server 2 (incomplete result) and SQLFetch on server 1 (correct result). Can someone please tell me when PHP calls SQLExtendedFetch in stead of SQLFetch? How can I configure PHP to use SQLFetch instead? Thanks! On Tue, Sep 16, 2008 at 4:25 PM, Micah Gersten <micah@xxxxxxxxxxx> wrote: > 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??? > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
