#27770 [Fbk->Bgs]: reading data from Access thrugh COM function

ID: 27770 Updated by: sniper@php.net Reported By: kaija_jan at hotmail dot com -Status: Feedback +Status: Bogus Bug Type: COM related Operating System: windows 2k PHP Version: 5.0.0RC1 New Comment: See Wez's comment.. Previous Comments: ------------------------------------------------------------------------ [2004-03-30 05:21:45] wez@php.net Please indicate how the data is different. Also, are you sure that your example script is correct? $oRs->Fields->["test"]->value ^^^^ this looks bogus $oRs->Release() won't work in PHP 5 Please read this for more information: http://www.zend.com/php5/articles/php5-dotnet.php ------------------------------------------------------------------------ [2004-03-30 04:12:19] kaija_jan at hotmail dot com Description: ------------ i try to use COM function to read data from Access database. but if the fields type is ole object. the data will different with the asp code. here is my php code. the type of field "test" is oleobject. there is no error during run time. Reproduce code: --------------- <? $oConn = new COM("ADODB.Connection"); $oConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb"); $oRs = $oConn->Execute("select * from test"); $a = "c:\abc"; while(!$oRs->EOF) { $Data = $oRs->Fields->["test"]->value; $oRs->MoveNext(); } $oRs->Close(); $oConn->Close(); $oRs->Release(); unset($oRs); unset($oConn); ?> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27770&edit=1