i did this : $oConn = new COM("ADODB.Connection"); $oConn ->ConectionString = <<<<<<<<string>>>>>>>> ; the next command works fine: $oConn->Execute( "insert into Paciente (nid,nombre,Apell1,Apell2,Sexo,NHisto,FNac) values (10042,'wfcwsfvwsvcsw','ewfrewfrew','dsfdsfsf','Hombre','121219',to_date('12 /1/1980','MM-DD-YYYY')) "); but if i execute this one the php fails with an error of memory: $oConn->Execute("insert into Peticion (NID,NPet,NPac,Diagnostico,FPet,Medico,Servicio,FPetFin,nidPass,obsPet,obsIn f,codSer,itt) values (10060,'56',10040,3,to_date('29-03-2001','DD-MM-YYYY'),'Julian','urgencias ',to_date('12-1-2001','DD-MM-YYYY'),1,'oooo','ttt','urgencias ','vv')"); if i copy into a sql tool and execute it works fine!!!!. Somebody knows why? Regards -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]