Hello all. I have been using COM calls from PHP for some time now in IIS and everything works fine. I have changed jobs lately (and servers) and now, i can't seem to get COM to work with PHP. The differences (major) between the two boxes are:
Box 1: (PHP COM calls working)
Windows Advanced Server 2000 running IIS
PHP 4.3.x running in CGI mode
PHP info can't be found on this box
Box 2: (PHP COM calls not working)
Windows XP Professional running Apache
PHP 4.3.1 running in ISAPI mode
PHP info can be found here: http://dev.postcards4insur
I try to run the following script:
<?php
$objConnection = new COM("ADODB.Connection");
phpinfo();
?>
and i get this: http://dev.postcards4insur
now, don't tell me that i shouldn't be connecting to databases this way through PHP, because that isn't my problem ;-). I used the ADODB.Connection ProgID because it is very common and is installed on this machine. In my actual environment, I will be using an custom COM object written by another developer.
Thanks! and any help is greatly appreciated.
-Chris
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
that would be a lovely idea, and no i haven't tried it.
one problem: that ini file was on my old employer's box, and well, needless to say, i am now in competition with him, so i really doubt he'd let me poke around his php.ini file. I tried looking for files that contained phpinfo() as well, but couldn't find any.
i know. this sounds like a stupid issue here. If i can't resolve it, we might have to switch to IIS. something i would rather not do. not that i don't care for IIS, but because it would involve increased costs.
I could be wrong, i mean, maybe this isn't an issue with apache at all. I just think it might be, because IIS worked fine in the past (on another box)
Thanks for your help!
-Chris
Here's my extentions section in my php.ini file. and yes, i have 1 php.ini file, i'm not running 2 on accedent =)
;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.
;
extension=php_bz2.dll
;extension=php_ctype.dll
extension=php_cpdf.dll
;extension=php_curl.dll
;extension=php_cybercash.d
;extension=php_db.dll
;extension=php_dba.dll
extension=php_dbase.dll
;extension=php_dbx.dll
;extension=php_domxml.dll
;extension=php_dotnet.dll
;extension=php_exif.dll
;extension=php_fbsql.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_hyperwave.d
;extension=php_iconv.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
;extension=php_imap.dll
;extension=php_ingres.dll
;extension=php_interbase.d
;extension=php_java.dll
;extension=php_ldap.dll
;extension=php_mbstring.dl
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
extension=php_pdf.dll
;extension=php_pgsql.dll
;extension=php_printer.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
extension=php_sockets.dll
;extension=php_sybase_ct.d
;extension=php_tokenizer.d
extension=php_w32api.dll
;extension=php_xslt.dll
;extension=php_yaz.dll
;extension=php_zlib.dll
Go through the Configuration of PHP section of this page
http://www.lameindustries.
Joel
Hi everyone,
Thanks for getting back to me! =)
zombieooo: I tried copying those files to c:\winnt\system32 but i still had a problem. Also, i tried going through the tutorial, but i can't do too much because this is a production server so i don't want to bring down sites. I did confirm that i followed those steps pretty acurately though.
alexhogan: you might be right. i remember i had be using other versions of php when i found problems with this before. i will try this in a bit.
another thing that should be noted, although perhaps not related... i have a cron job that runs nightly for backups. the script is written in php and the job uses php.exe to parse through it. it seems that lately the php script interpreter has been crashing. maybe my install is f***ked. i guess we'll see.
-Chris
Thanks alexhogan! that worked just fine.. I had upgraded PHP in the past with no success, but this version seems to work.
now, it doesn't work for the app i need it yet, but that is an error i can deal with... hopefully =)
i created another post for this, and i'm not sure how i award you points for this, so could you just post your solution on this thread:
http://www.experts-exchang
and i will award the points there.
Thanks. And thank you all for your help! Much appriecated!
-Chris
Business Accounts
Answer for Membership
by: jkna_gunnPosted on 2004-03-22 at 01:49:12ID: 10647684
is apache running under the system account?
you could try changing it to another account and see if that works