argh (IT question) - Does anyone here know PHP ?

[Skittles]

Getting a PHP encountered an Access Violation at (hex address) on a line of code trying to create a new COM object for an Excel application.

The code runs fine on each of my development servers running PHP 4.4.8 and 5.2 with Apache 2. The production server is Windows Server 2003 with IIS 6.0 running PHP 4.4.8.

I知 not very familiar with Windows Server and I wonder if this could be an environment difference?

[proud patriot]

1. no but I'll kick this hoping someone who does sees it

:hi:

[tabatha]

2. Probably.

Not an expert by any means, but there are some environment variables that are set before installing PHP - that can be different on different machines.

You can install a local network on your own computer - with IIS - and then install PHP, and test before moving to a server.

[Tandalayo_Scheisskopf]

3. I am not a PHP wizard by any means...

But I do play with it during the administration and general rasslin' with the website I admin. I would say that PHP is either setup wrong or not setup at all.

Time to talk with one of your IT weenies, Skittles m'dear. If you have never setup PHP yourself, don't go trying it. Also, if you do go trying it, the IT weenies might get your butt in a sling.

[BlooInBloo]

4. Sounds like not a php problem per se, but a win2k3 permissions setup problem....

But I don't do web stuff, only cpp/cs.

[nebenaube]

6. I do cpp/c & php but what is cs? n/t

[BlooInBloo]

7. C# - just too lazy to hit the SHIFT key. :P

[nebenaube]

8. fuck that...

microsuck is no longer worthy...

[BlooInBloo]

9. (shrug) I don't wrap my self-worth up in who the maker of the language I use is....

It's just not an important thing to me.

[nebenaube]

5. I would...

I would make sure that the COM object is completely registered with the system (an that you are calling the correct quid) also I'd make damn sure you don't have two guids for the same object!!!

[Skittles]

10. ....

with windows server, how do I ensure the COM obect is registered? :o

[DS1]

14. if it's a dll

open a dos command window, navigate to where the dll is then type

regsvr32 (name of dll)

that should do it

[tabatha]

11. You can also search this site and ask questions.

http://www.php.net/

[Skittles]

12. see that's why I came here

could not find answer there or anywhere :o

[DS1]

13. If you can configure the IIS server, make SURE it's using the php-cgi

engine to handle .php pages, and not php5isapi.dll. The DLL crashes ALL THE TIME.

This fixed a whole load of headaches I was having a few months ago. I also develop on Apache then upload to IIS for production.

[Skittles]

16. howdy DS1

Ok; I ran the dcomcnfg and found that access was denied for the IUSR which I think is why I知 getting the access violation. I think I知 on the right track here. I started following the instructions I found here:

http://www.phpbuilder.com/columns/venkatesan20030501.php3?page=1

In the middle of me registering the user names to Excel, the server went down. It could be for maintenance or it could be because they think someone is hacking in; I値l wait a bit and try again.

This server is an intranet server and has all the PHP and other security features set either off or low. Hopefully the client doesn稚 mind me fiddling with their setting. The php.ini file is almost set to the default developer setting. I upgraded them from PHP 4.4.6 to 4.4.8 today.

Does this sound like I知 on the right track? :o

[DS1]

17. do you have remote access?

if so, i'll take a look if you PM me the details. I'll be good, and write a list of things I'd suggest on a notepad window, instead of actually changing anything myself.

if not, fine, too. IUSR_blahblah will need write access to the php sesssions folder set in your php.ini file. and of course, at least read access to any server-local excel documents

[Skittles]

19. argh

I'll get back to you soon; another issue :o

[wtmusic]

15. This may help

http://www.vbulletin.com/forum/showthread.php?t=211513

Good luck.

[FormerOstrich]

18. Your Windows Server 2003...

probably doesn't have office installed so it can't instantiate the excel object....

maybe ....