Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Unanswered: Progress Dates to SQL Server

    I am extracting data from a Progress 9.1d Database to SQL Server 2000 using OPENQUERY using OpenLink Pro Lite ODBC 9.1d . I am encountering problems with Dates.

    SELECT *
    FROM OPENQUERY(LinkedServer,'SELECT DateA FROM Table1')

    I get the following error:

    Server: Msg 8114, Level 16, State 10, Line 1
    Error Converting data type DBTYPE_DBDATE to datetime

    This only occurs if the date on the progress side is not null or not a recognised format. IE 0006-12-25

    I have tried to handle this on the SQL Server side but nothing works as I beleive the failure is in the transition before I can handle it.

    Could anyone tell me what statement I need on the progress side to either convert this to a recognised format or to a character which I can convert once in SQL Server.

    Any help would be greatly appreciated.
    Last edited by Rattea; 11-25-03 at 10:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts