ADODB AppendParam problem??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, here is my code:

cmd = New ADODB.Command
If cnxIQ.State = 0 Then
cnxIQ.Open()
End If
cmd.let_ActiveConnection(cnxIQ)
cmd.CommandText = strProcedimiento
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append(cmd.CreateParameter("@param1", adInteger,
adParamInput, , 200506))
rsResultado = cmd.Execute //Here raise an exception

And run Fine on my laptop, but when I test it another PC raise an exception:
"Wrong number of parameters"

When I do debug seems all ok. This drive me crazy, because is the same code
working in one PC and not Working in the other ...

Both pc have installed Visual Studio.. in both pc I can do debug..

The target Database is Sybase IQ.

My last try was enable a query log in the database to see what sql was
generating the application and is not adding the parameter to the quey..

Any Idea?, Any patch missing ?

Thanks for the Help..
Regards
 
Ekempd,

Feel free to ask here, did you know that ADODB is not ADONET, for that are
other newsgroups.

Your problem is probably a DLL version problem. That is one of the reason
why there is Net and AdoNet, to get rid of the DLL hell.

I would check the ADODB related DLL's on both computers.

Typical ADODB newsgroup is by the way

microsoft.public.Data.ado
or
microsoft.public.dotnet.languages.vb.data

I hope this helps,

Cor
 
Back
Top