OLE DB command error;the OLE DB adapter cannot convert between types "DB_CY and "DT_TIMESTAMP".

• klineandking

  SSCrazy

  Points: 2570

  More actions

  December 29, 2011 at 7:16 am

  #265468

  i get this error when using the OLE DB Command it says it says "the OLE DB adapter cannot convert between types "DB_CY and "DT_TIMESTAMP".I have checked the data types for the row am mapping and its "DB_CY" but the parameter mapping still sees it to be DT_TIMESTAMP, i have also changed parameter to be "DB_CY" but i still get the error. what do i do any help is appreciated.

• rgtft

  Hall of Fame

  Points: 3518

  More actions

  December 29, 2011 at 1:04 pm

  #1426665

  Try running the T-SQL from your OLE DB Command in SSMS. Does it squawk about a conversion there? This might shed some light.

  HTH,

  Rob