Error convert DBTYPE_DBTIMESTAMP a datetime. As400 to sql server 2005

• dreker

  Valued Member

  Points: 70

  More actions

  August 6, 2007 at 7:44 am

  #180023

  Hello, i have this problem. when i try query over linked server of as400, this error occur.

  Error convert DBTYPE_DBTIMESTAMP a datetime

  I have this driver: client access odbc driver 9.00.10.00 . My sql server 2005 is standard. i cannot use the db2oledb driver because the sql 2005 is standard.

  The error is because i cannot convert dbtype_dbtimestamp of as400 to sql server.

  Can help me?

  Thanks.

   

   

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 6, 2007 at 9:10 am

  #724866

  What is the error? Can you not cast the date time to something along the lines of '1 Jan 2000 10:01:01:000' and do a convert

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• ArkWare

  Mr or Mrs. 500

  Points: 525

  More actions

  August 6, 2007 at 9:38 am

  #724886

  I've had this issue with translating JDEdwards dates running on an AS400.

  JDEdwards date format is: CYYDDD

  Had to import as datatype(INT) and used a function to translate.

  ArkWare