Hi all,

I'm having problems executing a sybase stored procedure in vb (6.0, serv pack 4). The stored procedure is of the form ("{ ? = call procName (?, ?) }"). We are executing it through an ADO command object. For reference, the code is included below.

with cmdMycommand
.ActiveConnection = cnnSybaseODBCConnection
.CommandType = adCmdStoredProc
Set prm1 = .CreateParameter("prm1", adChar, adParamInput, 9, str1)
Set prm2 = .CreateParameter("prm2", adChar, adParamInput, 1, str2)
Set prmReturn = .CreateParameter("prmReturn", adInteger, adParamOutput, 1)

.Parameters.Append prm1
.Parameters.Append prm2
.Parameters.Append prmReturn
.CommandText = "procName"
retMyrecordset.Open cmdMycommand, , adOpenDynamic, adLockBatchOptimistic, adCmdStoredProc

End With

This code executes correctly under Win 2000 with Sybase Open Client 12.0 but I get an error message when attempting execution under Win 2000 with Sybase Open Client 12.5.

I have no problems connecting to Sybase and retrieving recordsets using SELECTs -- just with the stored procedure. I have changed the DSN file I use to reflect the new parameters for 12.5. The 12.5 error message is included below

VB Error # -2147217839
Generated by MyApplicationName Microsoft OLE DB Provider for ODBC Drivers
Description Provider cannot derive parameter information and SetParameterInfo has not been called.
At Line number: 0
1. ADO Error #-2147217839
Description Provider cannot derive parameter information and SetParameterInfo has not been called.
Source Microsoft OLE DB Provider for ODBC Drivers


Any ideas what could be causing this?

Thanks