Error converting data type DBTYPE_DBDATE to datetime.

• Amit Vajpeyi

  SSC Journeyman

  Points: 80

  More actions

  May 10, 2005 at 12:58 pm

  #60837

  I have SQLServer 2000. Iam trying to connect to DB2 server to get data. The query which we are using is :-

  SELECT * FROM

     OPENROWSET('MSDASQL','DSN=DB2G;UID=XXX;PWD=XXX',

    'select s.se_no, s.data_per_dt, tot_dspt_ct, roc_to_dspt_rt,

  bill_dspt_over_ct,

       immed_chrgbk_ct, immed_chrgbk_am, tot_intl_chrgbk_ct,

  tot_intl_chrgbk_am,

     dspt_dt, card_no, case_no, dspt_rsn_cd, dspt_am

      from  vmus00.se_dispute_summary as s, vmus00.se_dispute_detail as

  d

      where s.se_no = d.se_no and s.data_per_dt = d.data_per_dt

        and month(s.data_per_dt) = 3

        and year(s.data_per_dt) = 2005

        and s.se_no = ''6312666308''')

   

  This query runs fine on few occasions. Sometimes i get the following error message :-

  Msg 8114, Level 16, State 10, Server NYKNTESWEB03, Line 1

  Error converting data type DBTYPE_DBDATE to datetime.

  Since this error is not consistant and is thrown sometimes so iam not able to figure out the problem. I have also looked the date field and it is showing correct dates in the results.

  Please help if any one knows about the solution for this problem.

   

  Thanks

  Amit

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  May 10, 2005 at 1:08 pm

  #557878

  What are the datatypes for vmus00.se_dispute_summary.data_per_dt  and

  vmus00.se_dispute_detail.data_per_dt

   

• Amit Vajpeyi

  SSC Journeyman

  Points: 80

  More actions

  May 10, 2005 at 1:39 pm

  #557884

  They are date fields in db2 table.