ODBC date problem
Posted in 2010
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues
I'm converting a program to use Informix as well as SQL, and am using the ODBC connection and have installed 3.70, connecting to IDS 11.5 on a windows server. There is one thing I have a problem with. I'm saving a date time and the time is getting set as 00:00:00 when using ODBC. If I use 'Server Studio' to send a direct SQL Statement, it updates fine so I know the server is OK (the field is set as DATETIME YEAR TO SECOND). I'm using Delphi to write the application, and if I use one driver (IBX) with a query direct, it again saves OK, but if I instead use the ADO driver, connecting via ODBC then I get the problem with truncating the dates. The client I'm doing the conversion for wants to use ODBC as it's how they already have things setup for other applications using Informix, otherwise I could spend more time with the IBX drivers of course. Anyone got any idea what to try to resolve this? Thanks Jeremy