#32133 [Com]: Failed create COM object
ID: 32133
Comment by: taylor dot ren at gmail dot com
Reported By: fLAre_Dra_X at yahoo dot com
Status: No Feedback
Bug Type: COM related
Operating System: Windows XP SP 2
PHP Version: 5.0.1
New Comment:
Acknowledged that the above solution works fine in Vista.
But there is a new error message when I tried:
$doc=$word-Documents-Add();
it says:
Word is unable to trigger event.
I have Office 2003 installed. I guess it is due to the Add method is
not the corrrect method name. Any hints?
Previous Comments:
[2006-01-03 13:31:17] ozovadia at hotmail dot com
Here is a possible solution:
Verify that the user has the appropriate permissions to start the DCOM
server.
1. In the Control Panel, double-click Administrative Tools, and then
double-click Component Services.
2. In the Component Services snap-in, expand Computers, expand My
Computer, and double-click DCOM Config.
3. In the right pane, locate the program you are trying to create.
4. Right-click the program name, and then select Properties. On the
Security tab, in the Launch and Activation Permissions group box, select
Customize, and then click Edit.
5. Add the user (e.g. running the IIS server) to the permissions list,
and give the user the appropriate permissions.
That should do it.
[2006-01-03 12:06:55] ozovadia at hotmail dot com
Installed the latest version (5.1.1.1) and still experiencing the same
problem.
[2005-03-20 18:10:26] [EMAIL PROTECTED]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to Open. Thank you.
[2005-02-28 19:58:40] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
[2005-02-28 15:58:43] fLAre_Dra_X at yahoo dot com
Description:
I've download the version of PHP :
http://snaps.php.net/win32/php5.0-win32-latest.zip
It's work to call COM class, but when create object like
word.application it failed.
My configuration is disable all COM option on php.ini like
com.allow_dcom. Is there any
configuration that i need to do with my php or with my IIS ???
Reproduce code:
---
?php
ini_set(com.allow_dcom,true);
// starting word
$word = new COM(word.application) or die(Unable to instanciate
Word);
print Loaded Word, version {$word-Version}\n;
//bring it to front
$word-Visible = 1;
//open an empty document
$word-Documents-Add();
//do some weird stuff
$word-Selection-TypeText(This is a test...);
$word-Documents[1]-SaveAs(Useless test.doc);
//closing word
$word-Quit();
//free the object
$word-Release();
$word = null;
?
Expected result:
Com object of word.
Actual result:
--
PHP Fatal error: Uncaught exception 'com_exception' with message
'Failed to create COM object `word.application': Access is denied. ' in
E:\Inetpub\wwwroot\tutor\com_word.php:4 Stack trace: #0
E:\Inetpub\wwwroot\tutor\com_word.php(4): com-com('word.applicatio...')
#1 {main} thrown in E:\Inetpub\wwwroot\tutor\com_word.php on line 4
--
Edit this bug report at http://bugs.php.net/?id=32133edit=1
#41509 [NEW]: PDO fetchAll for InterBase missing first row
From: taylor dot ren at gmail dot com
Operating system: Vista Business
PHP version: 5.2.2
PHP Bug Type: PDO related
Bug description: PDO fetchAll for InterBase missing first row
Description:
The code is simple: I just want to select 5 rows from my InterBase
database using PDO.
A live demo can be found: http://www.rsywx.net/smarty/test01.php.
It is very clear that the first row is not fetched (or missing) so the
output is missing BOOKID=1 and related information.
Same mechanism works fine for MySQL.
Reproduce code:
---
$PDO1=new PDO(firebird:dbname=localhost:f:\\data\\book.ib, iis,
iis);
print_r($PDO1-query('SELECT bookid, title, author FROM book order by
bookid rows 5')-fetchAll(PDO::FETCH_ASSOC));
Expected result:
Should have 5 records with BOOKID from 1 to 5.
Actual result:
--
Now 1 is missing.
--
Edit bug report at http://bugs.php.net/?id=41509edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=41509r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=41509r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=41509r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=41509r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=41509r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=41509r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=41509r=needscript
Try newer version:http://bugs.php.net/fix.php?id=41509r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=41509r=support
Expected behavior:http://bugs.php.net/fix.php?id=41509r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=41509r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=41509r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=41509r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41509r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=41509r=dst
IIS Stability:http://bugs.php.net/fix.php?id=41509r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=41509r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=41509r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=41509r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=41509r=mysqlcfg
#39494 [Opn]: Cannot fetch any row
ID: 39494
User updated by: taylor dot ren at gmail dot com
Reported By: taylor dot ren at gmail dot com
Status: Open
Bug Type: InterBase related
Operating System: XP
PHP Version: 5.2.0
New Comment:
Hi all,
The problem in this case is identified. In the sample code segment, I
found the problem is caused by the fact that tr has no select right
in table t1.
It is very strange that ibase_errmsg did not prompt out any errors!
Now I have changed my code to select from another more complex table
and got some other error msg. I will try to fix them by myself and then
seek help.
Please close this topic.
Previous Comments:
[2006-11-14 00:10:01] taylor dot ren at gmail dot com
Code segment:
body
?php
error_reporting(E_ALL);
echo Connection started. \n;
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
echo Dumping connection: , var_dump($connection);
echo Dumping ibase_errmsg: ,ibase_errmsg();
$sql='select * from t1';
$result=ibase_query($connection, $sql);
echo Dumping result: , var_dump($result);
echo Dumping fetch_row: , var_dump(ibase_fetch_row($result));
echo Dumping ibase_errmsg: , ibase_errmsg();
?
End of statement.
/body
Output:
Connection started. Dumping connection: resource(1) of type
(Firebird/InterBase link) Dumping ibase_errmsg: Dumping result:
bool(false) Dumping fetch_row: bool(false) Dumping ibase_errmsg: End of
statement.
[2006-11-13 23:48:38] [EMAIL PROTECTED]
Please enable error_reporting(E_ALL) at the top of the script and use
_function_ ibase_errmsg(), not variable $ibase_errmsg.
[2006-11-13 23:38:54] taylor dot ren at gmail dot com
Hi Tony,
Thanks again.
Code segment now looks like this:
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
var_dump($ibase_errmsg);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump($ibase_errmsg);
?
End of statement.
===
Output now is:
resource(1) of type (Firebird/InterBase link) NULL bool(false)
bool(false) NULL End of statement.
Any further comments?
/body
[2006-11-13 12:59:33] [EMAIL PROTECTED]
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
Are you sure? There are 4 (four) var_dump() calls, but you showed 3.
What if you put ibase_errmsg() right after the ibase_query() call?
[2006-11-13 12:48:04] taylor dot ren at gmail dot com
Hi Tony,
Thanks for your quick fdbk.
The output is like this per your suggest script:
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
It seems to me the connection to InterBase is fine but the $result
fails after call to ibase_query()... as it returns false...
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/39494
--
Edit this bug report at http://bugs.php.net/?id=39494edit=1
#39494 [NEW]: Cannot fetch any row
From: taylor dot ren at gmail dot com
Operating system: XP
PHP version: 5.2.0
PHP Bug Type: InterBase related
Bug description: Cannot fetch any row
Description:
I installed PHP with IIS and opened InterBase ext.
1. IB is OK. I can run separately developed Win32 programs.
2. PHP is OK. I can load a PHP test file with as simple as phpinfo();
3. ibase_ functions seems OK because there is no error message
prompted.
4. Database/table name OK.
PHP Interbase script:
Tried in Firefox IE6.
Reproduce code:
---
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr', 'enigma',
'gb_2312');
$sql='select * from t1';
$result=ibase_query($connection, $sql);
while($row=ibase_fetch_object($result))
{
echo (int)$row-id1, \n;
}
ibase_free_result($result);
ibase_close($connection);
?
End of statement.
/body
Expected result:
I am expecting something like:
1
2
Actual result:
--
but only the last HTML statement:
End of statement was displayed.
--
Edit bug report at http://bugs.php.net/?id=39494edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=39494r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=39494r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=39494r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=39494r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=39494r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=39494r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=39494r=needscript
Try newer version:http://bugs.php.net/fix.php?id=39494r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=39494r=support
Expected behavior:http://bugs.php.net/fix.php?id=39494r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=39494r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=39494r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=39494r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39494r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=39494r=dst
IIS Stability:http://bugs.php.net/fix.php?id=39494r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=39494r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=39494r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=39494r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=39494r=mysqlcfg
#39494 [Opn]: Cannot fetch any row
ID: 39494
User updated by: taylor dot ren at gmail dot com
Reported By: taylor dot ren at gmail dot com
Status: Open
Bug Type: InterBase related
Operating System: XP
PHP Version: 5.2.0
New Comment:
BTW, the PHPinfo() prompts the below Interbase related info:
interbase
Firebird/InterBase Support dynamic
Compile-time Client Library Version Interbase 6
Run-time Client Library Version WI-V7.5.1.80
Is it because I am using IB 7.5 but the compile time lib is only IB 6?
Previous Comments:
[2006-11-13 12:24:47] taylor dot ren at gmail dot com
Description:
I installed PHP with IIS and opened InterBase ext.
1. IB is OK. I can run separately developed Win32 programs.
2. PHP is OK. I can load a PHP test file with as simple as phpinfo();
3. ibase_ functions seems OK because there is no error message
prompted.
4. Database/table name OK.
PHP Interbase script:
Tried in Firefox IE6.
Reproduce code:
---
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
$sql='select * from t1';
$result=ibase_query($connection, $sql);
while($row=ibase_fetch_object($result))
{
echo (int)$row-id1, \n;
}
ibase_free_result($result);
ibase_close($connection);
?
End of statement.
/body
Expected result:
I am expecting something like:
1
2
Actual result:
--
but only the last HTML statement:
End of statement was displayed.
--
Edit this bug report at http://bugs.php.net/?id=39494edit=1
#39494 [Fbk-Opn]: Cannot fetch any row
ID: 39494
User updated by: taylor dot ren at gmail dot com
Reported By: taylor dot ren at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: InterBase related
Operating System: XP
PHP Version: 5.2.0
New Comment:
Hi Tony,
Thanks for your quick fdbk.
The output is like this per your suggest script:
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
It seems to me the connection to InterBase is fine but the $result
fails after call to ibase_query()... as it returns false...
Previous Comments:
[2006-11-13 12:29:55] [EMAIL PROTECTED]
What do you get with this script?
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump(ibase_errmsg());
?
[2006-11-13 12:28:17] taylor dot ren at gmail dot com
BTW, the PHPinfo() prompts the below Interbase related info:
interbase
Firebird/InterBase Support dynamic
Compile-time Client Library Version Interbase 6
Run-time Client Library Version WI-V7.5.1.80
Is it because I am using IB 7.5 but the compile time lib is only IB 6?
[2006-11-13 12:24:47] taylor dot ren at gmail dot com
Description:
I installed PHP with IIS and opened InterBase ext.
1. IB is OK. I can run separately developed Win32 programs.
2. PHP is OK. I can load a PHP test file with as simple as phpinfo();
3. ibase_ functions seems OK because there is no error message
prompted.
4. Database/table name OK.
PHP Interbase script:
Tried in Firefox IE6.
Reproduce code:
---
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
$sql='select * from t1';
$result=ibase_query($connection, $sql);
while($row=ibase_fetch_object($result))
{
echo (int)$row-id1, \n;
}
ibase_free_result($result);
ibase_close($connection);
?
End of statement.
/body
Expected result:
I am expecting something like:
1
2
Actual result:
--
but only the last HTML statement:
End of statement was displayed.
--
Edit this bug report at http://bugs.php.net/?id=39494edit=1
#39494 [Fbk-Opn]: Cannot fetch any row
ID: 39494
User updated by: taylor dot ren at gmail dot com
Reported By: taylor dot ren at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: InterBase related
Operating System: XP
PHP Version: 5.2.0
New Comment:
Hi Tony,
Thanks again.
Code segment now looks like this:
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
var_dump($ibase_errmsg);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump($ibase_errmsg);
?
End of statement.
===
Output now is:
resource(1) of type (Firebird/InterBase link) NULL bool(false)
bool(false) NULL End of statement.
Any further comments?
/body
Previous Comments:
[2006-11-13 12:59:33] [EMAIL PROTECTED]
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
Are you sure? There are 4 (four) var_dump() calls, but you showed 3.
What if you put ibase_errmsg() right after the ibase_query() call?
[2006-11-13 12:48:04] taylor dot ren at gmail dot com
Hi Tony,
Thanks for your quick fdbk.
The output is like this per your suggest script:
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
It seems to me the connection to InterBase is fine but the $result
fails after call to ibase_query()... as it returns false...
[2006-11-13 12:29:55] [EMAIL PROTECTED]
What do you get with this script?
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump(ibase_errmsg());
?
[2006-11-13 12:28:17] taylor dot ren at gmail dot com
BTW, the PHPinfo() prompts the below Interbase related info:
interbase
Firebird/InterBase Support dynamic
Compile-time Client Library Version Interbase 6
Run-time Client Library Version WI-V7.5.1.80
Is it because I am using IB 7.5 but the compile time lib is only IB 6?
[2006-11-13 12:24:47] taylor dot ren at gmail dot com
Description:
I installed PHP with IIS and opened InterBase ext.
1. IB is OK. I can run separately developed Win32 programs.
2. PHP is OK. I can load a PHP test file with as simple as phpinfo();
3. ibase_ functions seems OK because there is no error message
prompted.
4. Database/table name OK.
PHP Interbase script:
Tried in Firefox IE6.
Reproduce code:
---
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
$sql='select * from t1';
$result=ibase_query($connection, $sql);
while($row=ibase_fetch_object($result))
{
echo (int)$row-id1, \n;
}
ibase_free_result($result);
ibase_close($connection);
?
End of statement.
/body
Expected result:
I am expecting something like:
1
2
Actual result:
--
but only the last HTML statement:
End of statement was displayed.
--
Edit this bug report at http://bugs.php.net/?id=39494edit=1
#39494 [Fbk-Opn]: Cannot fetch any row
ID: 39494
User updated by: taylor dot ren at gmail dot com
Reported By: taylor dot ren at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: InterBase related
Operating System: XP
PHP Version: 5.2.0
New Comment:
Code segment:
body
?php
error_reporting(E_ALL);
echo Connection started. \n;
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
echo Dumping connection: , var_dump($connection);
echo Dumping ibase_errmsg: ,ibase_errmsg();
$sql='select * from t1';
$result=ibase_query($connection, $sql);
echo Dumping result: , var_dump($result);
echo Dumping fetch_row: , var_dump(ibase_fetch_row($result));
echo Dumping ibase_errmsg: , ibase_errmsg();
?
End of statement.
/body
Output:
Connection started. Dumping connection: resource(1) of type
(Firebird/InterBase link) Dumping ibase_errmsg: Dumping result:
bool(false) Dumping fetch_row: bool(false) Dumping ibase_errmsg: End of
statement.
Previous Comments:
[2006-11-13 23:48:38] [EMAIL PROTECTED]
Please enable error_reporting(E_ALL) at the top of the script and use
_function_ ibase_errmsg(), not variable $ibase_errmsg.
[2006-11-13 23:38:54] taylor dot ren at gmail dot com
Hi Tony,
Thanks again.
Code segment now looks like this:
body
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
var_dump($ibase_errmsg);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump($ibase_errmsg);
?
End of statement.
===
Output now is:
resource(1) of type (Firebird/InterBase link) NULL bool(false)
bool(false) NULL End of statement.
Any further comments?
/body
[2006-11-13 12:59:33] [EMAIL PROTECTED]
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
Are you sure? There are 4 (four) var_dump() calls, but you showed 3.
What if you put ibase_errmsg() right after the ibase_query() call?
[2006-11-13 12:48:04] taylor dot ren at gmail dot com
Hi Tony,
Thanks for your quick fdbk.
The output is like this per your suggest script:
resource(1) of type (Firebird/InterBase link) bool(false) bool(false)
It seems to me the connection to InterBase is fine but the $result
fails after call to ibase_query()... as it returns false...
[2006-11-13 12:29:55] [EMAIL PROTECTED]
What do you get with this script?
?php
$connection = ibase_connect('localhost:f:/data/test.ib', 'tr',
'enigma', 'gb_2312');
var_dump($connection);
$sql='select * from t1';
$result=ibase_query($connection, $sql);
var_dump($result);
var_dump(ibase_fetch_row($result));
var_dump(ibase_errmsg());
?
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/39494
--
Edit this bug report at http://bugs.php.net/?id=39494edit=1
