Error converting datatypes.

• Joakim Krassman

  Old Hand

  Points: 347

  More actions

  January 19, 2005 at 7:45 am

  #163163

  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

   

   

   

   

• January 24, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 24, 2005 at 1:26 pm

  #538814

  If I understand you right, see if this helps:

  http://www.davidpenton.com/testsite/scratch/adodb.command3.asp

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]