Hi, everyone!
We have just upgraded our SQL server from 7.0 to 2000, and we have stumbled into some conversion problems in COM++ object.
1. We are using variant as input variable in the function header in our COM class (VB6).
2. Then we use as adDouble for the parameter when executing the stored procedure.
This works fine in SQL 7 environment, but it does not work as it should in sql2000. The conversion with decimal fails and often it removes the delimiter.
Any ideas why we need to change the function header to double? Any fixes?
Best regards, Joakim