DataTypedifferences between ADO and Informix Client 2.90?

Hi, My developer environment: Informix Client 2.90 / Server 10.0 ADO 2.8 VB6 After I changed the Informix-Client and Informix-Server-Version (before 2.20 / 7.31 after 2.90 / 10.0) my routines for execute the stored procedures send Errors. Before it was possible to transfer the values without consideration of valuetype, the system was very type-tolerant. My Code: Public cmm As New Adodb.Command Public SP_Array() As Variant ReDim SP_Array(SP_Number) SP_Array(0) = 10 SP_Array(1) = "test" cmm.ActiveConnection = inf cmm.CommandText = SP_Name cmm.CommandType = adCmdStoredProc '---Input-Parameter For i% = 0 To cmm.Parameters.Count - 1 cmm.Parameters(i) = SP_Array(i) Next '---Execute Set RS = cmm.Execute But the newest version is very retrictiv and I allways get the ADO-errormessage: 3421 "Data type conversion error" at the row : cmm.Parameters(i) = SP_Array(i) My question is: Who knows a general solution for this problem? thanks

Michael Andreas wrote: <snip> > Informix Client 2.90 / Server 10.0 <snip> Which provider are you using ? e.g. OLEDB Have you checked the mappings ? http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.oledb.doc/oledbmst41.htm Rich

Hi Rich, thanks for your email. Yes OLEDB I am not the database-administrator. I looked for the IBM-link but what shall I do that the program runs? thanks "Rich or Krist'n" <informix.databases@geos.com> schrieb im Newsbeitrag news:1157549486.115675.16010@p79g2000cwp.googlegroups.com... > > Michael Andreas wrote: > <snip> >> Informix Client 2.90 / Server 10.0 > <snip> > > Which provider are you using ? e.g. OLEDB > > Have you checked the mappings ? > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.oledb.doc/oledbmst41.htm > > Rich >