Hi,
VB6, ADO2.8, Informix Client 2.90 / Server 10.0

with the following code I should be able to start a stored procedure.
The right parameters are automaticly generated by the command:
Parameters.Refresh

I get the error :
Error 3708
The application has improperly defined a Parameter object.

- I can start other sp's
- significant is a variable of type adVarBinary at this sp


My Questions:
- Infomix unsupported the Parmeters.Refresh ?
- who is able to help me?

thanks


'BeginAutoParamCmd
' Set CommandText equal to the stored procedure name.
objCmd.CommandText = "CustOrdersOrders"
objCmd.CommandType = adCmdStoredProc

' Connect to the data source.
Set objConn = GetNewConnection
objCmd.ActiveConnection = objConn

' Automatically fill in parameter info from stored procedure.
objCmd.Parameters.Refresh

' Execute once and display...
Set objRs = objCmd.Execute

Hi there,
can you please list the actual stored procedure that you are trying to
execute from VB?

thanks

Michael Andreas wrote:
> Hi,
> VB6, ADO2.8, Informix Client 2.90 / Server 10.0
>
> with the following code I should be able to start a stored procedure.
> The right parameters are automaticly generated by the command:
> Parameters.Refresh
>
> I get the error :
> Error 3708
> The application has improperly defined a Parameter object.
>
> - I can start other sp's
> - significant is a variable of type adVarBinary at this sp
>
>
> My Questions:
> - Infomix unsupported the Parmeters.Refresh ?
> - who is able to help me?
>
> thanks
>
>
> 'BeginAutoParamCmd
> ' Set CommandText equal to the stored procedure name.
> objCmd.CommandText = "CustOrdersOrders"
> objCmd.CommandType = adCmdStoredProc
>
> ' Connect to the data source.
> Set objConn = GetNewConnection
> objCmd.ActiveConnection = objConn
>
> ' Automatically fill in parameter info from stored procedure.
> objCmd.Parameters.Refresh
>
> ' Execute once and display...
> Set objRs = objCmd.Execute

another thing to try might be calling the stored proc with the correct
number of parameters like

objCmd.CommandText = "CustOrdersOrders(?,?) for 2 params for example


maccathuil wrote:
> Hi there,
> can you please list the actual stored procedure that you are trying to
> execute from VB?
>
> thanks
>
> Michael Andreas wrote:
> > Hi,
> > VB6, ADO2.8, Informix Client 2.90 / Server 10.0
> >
> > with the following code I should be able to start a stored procedure.
> > The right parameters are automaticly generated by the command:
> > Parameters.Refresh
> >
> > I get the error :
> > Error 3708
> > The application has improperly defined a Parameter object.
> >
> > - I can start other sp's
> > - significant is a variable of type adVarBinary at this sp
> >
> >
> > My Questions:
> > - Infomix unsupported the Parmeters.Refresh ?
> > - who is able to help me?
> >
> > thanks
> >
> >
> > 'BeginAutoParamCmd
> > ' Set CommandText equal to the stored procedure name.
> > objCmd.CommandText = "CustOrdersOrders"
> > objCmd.CommandType = adCmdStoredProc
> >
> > ' Connect to the data source.
> > Set objConn = GetNewConnection
> > objCmd.ActiveConnection = objConn
> >
> > ' Automatically fill in parameter info from stored procedure.
> > objCmd.Parameters.Refresh
> >
> > ' Execute once and display...
> > Set objRs = objCmd.Execute