ASP [Oracle][ODBC]Syntax error or access violation?

Question

Hi,
I am calling the ORACLE procedure from ASP file as given below
dim return_code
dim cmd
dim lngrecs
set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = connection_string
.commandtype=4
.CommandText = "CS_OWNER.sp_authenticate"
.Parameters.append .createparameter("@i_uid",201,1,10)
.Parameters.append .createparameter("@i_pwd",201,1,10)
.Parameters.append .createparameter("@o_valid",3,2)
.Parameters("@i_uid") = emplid
.Parameters("@i_pwd") = pwd
.execute lngrecs, ,128
return_code = .Parameters("@o_valid")
End With

I am getting the error in the following line
.execute lngrecs, ,128

error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Oracle][ODBC]Syntax error or access violation.

/support/sales/order_entry/inc.asp, line 789

anybody can help me.

thanks in advance
Lava

Answer 1

Check the linker code.

Answer 2

do a simple connection to sp which returns a select * from xyz, without parameter...If ok, go ahead with parameter.

I think link to db is giving failure