Re: COM problem with ADO

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/