Llamada a Stored Procedure
Publicado por Francisco Rosello (1 intervención) el 03/11/2005 19:54:28
Hola señores: Tengo un problema al ejecutar el siguiente codigo:
set cn=server.CreateObject("ADODB.connection")
set reclocal=Server.CreateObject("ADODB.Recordset")
cn.ConnectionTimeout = 60000
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=w_soat;Initial Catalog=soat;data source=SERVIDOR"
set cmd = Server.CreateObject("ADODB.COMMAND")
set cmd.ActiveConnection = cn
cmd.CommandText = "SELECT_WITH_PAGING"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Refresh
El mensaje de error es:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another., line 14. La linea es la del cmd.CommandType = adCmdStoredProc
Gracias
set cn=server.CreateObject("ADODB.connection")
set reclocal=Server.CreateObject("ADODB.Recordset")
cn.ConnectionTimeout = 60000
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=w_soat;Initial Catalog=soat;data source=SERVIDOR"
set cmd = Server.CreateObject("ADODB.COMMAND")
set cmd.ActiveConnection = cn
cmd.CommandText = "SELECT_WITH_PAGING"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Refresh
El mensaje de error es:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another., line 14. La linea es la del cmd.CommandType = adCmdStoredProc
Gracias
Valora esta pregunta
0