var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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 09:31.