Re: COM problem with ADO

Oh, the @ sign will supress the error, but in fact, the COM donesn't work at all. > Wherever the warning is there : > > put @ sign. > > like @$dbc->Open..... like that... it'll handle the > exceptions > > --- phpme <phpme@citiz.net> wrote: > Hi, all > > > > I have setup PHP to work with ADO, but It's so hard > > to made them work: > > > > $dbc = new COM("ADODB.Connection"); > > $dbc->Provider = "sqloledb"; > > > $dbc->Open('DSN=starmate;Database=magway;UID=sa;PWD='); > > //OK > > $q="select title from css"; > > > > //1. command object > > $cm= new COM("ADODB.Command"); > > $cm->CommandText=$q; > > $cm->ActiveConnection=$dbc; //PropPut() failed!!! > > $rs=$cm->Execute(); //Invoke() failed!!! > > // > > > > //2. recordset still don't work > > $rs=new COM("ADODB.Recordset"); > > $rs->Open($q); //Invoke() failed!!! > > > > //only this code will work > > $rs=$dbc->Execute($q); > > echo $rs->fields[0]->value . "<br>"; > > > > > > On the other hand, all the Double byte char > > input/output will be cut to > > 1byte. 测试a will be changed to 3 byte char. > > > > > > > > regards, > > steeven > > > ===== > To Find Out More About Me : http://mukul.tsx.org/ > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/