Re: DataTypedifferences between ADO and Informix Client 2.90?

Michael Andreas wrote: > 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 <snip> Hi Michael, I've just read your other post, I don't think you'll be able to use the parameters.refresh method to auto-generate the ADO parameters. I've just tried it against a UDR with 3 integer input arguments and the resultant ADO parameters are of type adParamUnknown (not very promising!), - unsurprisingly I then get the same error as you "Parameter object is improperly defined...". I'm not sure which provider method ADO calls to get the info (GetColumnInfo on the IColumnsInfo interface???), the provider release notes indicate that it should be possible, but if common types like integers and varchars aren't mapped properly it doesn't look like you'll be able to use it. I have tried it with the ODBC driver and it looks like it would work. I would suggest a call to IBM support to confirm (or not!) the issue with OLEDB. If you must use OLEDB then you will have to find another way to define your ADO parameters, e.g. hard-coded to match the UDR, or perhaps you can query some of the system tables up front to pull out the arguments and do the data type mappings yourself ? Regards, Rich