Hola, quisiera saber si este query esta bien porque me marca un error de:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Gracias.
strCon = "driver={SQL Server};server=VECTRA;uid=sa;pwd=;database=Base&qu ot;
set conn = Server.CreateObject("ADODB.Connection")
set RS = Server.CreateObject("ADODB.Recordset")
set RS2 = Server.CreateObject("ADODB.Recordset")
conn.open(strCon)
' Llenamos la tabla Status '
SQL = "Delete from Status"
SQL2 = "Insert into Status Select MEANING, count(*) from P1_ORDENES_COMPLETADAS where DATE_COMPLETED between '"& fechaini &"' and '" & fechafin & "' group by MEANING"
Set RS= Conn.Execute(SQL)
Set RS2= Conn.Execute(SQL2)
RS.open SQL, conn
RS2.open SQL2, conn
%>
<%
Do While Not Rs.EoF
%>
PD. Alguien sabe de conexion de Oracle con ASp
