Not Getting All Results From MSSQL Linked Server Query

[MikeBronner]

Hi everyone!

I am experiencing a very strange bug using PEAR:MDB2 in conjunction with my MS SQL 2000 Server, which has some Oracle servers set up as linked servers.

Here's the problem: If I run a query against just the MS SQL Server I get all records as expected. However, if I join these results against a linked server database to show the corresponding records in the database as well, I get far fewer than expected records in PHP, while I get all records when running the exact same query in Enterprise Manager. In fact, the more queries that go against the linked server, the fewer records I get returned in PHP (while Enterprise Manager consistantly returns all records).

This tells me that the problem lies either with PHP or MDB2, and I am not sure how to narrow it down or even fix it. Does anyone have any ideas on how I could go about tracking this down further (or even have a fix for it)?

Thanks a lot guys!

Mike

Take Care,
Mike

 

[jpadie]

shot in the dark here (as i have little experience in MSSQL and Oracle): could it be a buffering issue in the driver used by mdb2?

if you don't get a good answer from this forum you might get a more fulsome response from the pear mailing list as the writers of the mdb2 class participate there.

 

[MikeBronner]

Thanks for your reply. The buffering issue makes a lot of sense. I was suspecting something similar, because if I add too many queries that reference the linked server, I don't get any results at all, and the page won't even render; it seems like PHP ends up choking on it and dies without a whimper (no error shown).
Unfortuantely I wouldn't know how to debug this.

I'll try to get this on the mailing list you mentioned as well.

Cheers,
Mike