The IBMDA400 provider seems to convert dates to character values even when using keyword "Convert Date Time To Char=FALSE". This does not happen with the ODBC driver or IBMDASQL provider. I'd be okay with IBMDASQL except IBM states it only works the SQL statements. I'd be okay with ODBC driver except records can be doubled when using it with Windows 7 Pro 64 bit and Client Access 7.1.
 Is there a way to convert dates to PC Date values with IBMDA400?
 Is there a better provider that works with XP - Windows 7 PCs?
 Is there a way to prevent the ODBC driver from doubling records in Windows 7?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!