Unanswered: Problems with VB6.0 Recordset - openlink odbc
I am using Openlink lite to extract information from a Progress application into Microsoft SQL using Visual Basic. I can connect to the Progress DB and extract all information except dates into SQL. When I try and select dates I get a "Data provider or other service returned an E_Fail Status". In debug mode it shows Native Error -2147217887, SQLSTATE empty, defined size 6, and date "#7/7/2003#". I have tried manipulating the regional settings on the PC. Does anyone have any ideas on what may be causing this problem.