Local oConn as ADODB.Connection, lcString as String *************************************************** oConn = CreateObject("ADODB.Connection") Text to lcString textmerge noshow pretext 1 Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=password;Initial Catalog=scd4;Data Source=Server EndText *************************************************** oConn.ConnectionString = lcString oConn.Open() oConn.Execute("Set dateformat dmy") && Formata a data da conexão pra DMY *************************************************** Clear Set Step On lcInstruc = "Select top 3 * from Distr where Dis_DT < '18/08/2004'" rs = oConn.Execute(lcInstruc) && Funciona ?rs.Fields("Dis_DT").Value && Comprova que o Execute anterior, realmente, funcionou *************************************************** lcSql = "Select Ped_Cod from PedCert where Ped_Usu_Imp = 0" loRS = oConn.Execute(lcSQL) && Executo outro Select qualquer - também funciona ?loRS.Fields(0).Value && Comprova que o Execute anterior, realmente, funcionou *************************************************** rs = oConn.Execute(lcInstruc) && Agora aquele primeiro Execute não funciona mais dando erro de formato de data