FMS Advanced / ODBC / Apace or IIS

[SEI]

Has anyone else tried running Apache or IIS on the same machine as FMS Advanced and make ODBC calls to FMS?

It seems to wrk OK with FMDevel, but when using FMS it eats up all the memory and crashes on me.

Is there a document somewhere that says not to do this that I haven't seen yet?

[SEI]

Well on one server it causes PHP to eat everything, and on the other it runs perfectly. I can't explain it.

But now on the bad server I only get the last record worth of data, all the others turn out blank.

This is insane!

[SEI]

OK, solved the one.5 records worht of data issue. I had to use the 1.10.00 ODBC driver that came with FM Developer, not the 1.1.503 ODBC driver that came with Server Advanced. That's preposterious, but as usual it's something i should come to expect. Anyway, now I have some slow web pages. It takes 3-5 seconds to draw the pages, but takes less that 1 when i comment out the DB calls. [color:"red"] Has anyone else seen this?

[Steve T.]

Hi, SEI! I don't use IIS or FM7SA and know squat about ODBC, but I remember users mentioning that FileMaker ODBC is not exactly speedy. There should be some posts on it (I remember 1 from Mariano Peterson) but it's been a while and way before FM7. From what I understand/remember, it's better to go with XML with PHP et. al. instead. I could be wrong, but that's what I kinda fuzzy-like remember... hope it helps.

--ST