Douglas DeFreece 12.May.10 03:24 PM a Web browser Connector for ODBCAll ReleasesAll Platforms
I am trying to use the ODBC NotesSQL ver 8.5.1 to pull data to Oracle 10g for OBIEE Reporting. I am using VB.NET 2008 connectiing using the driver. I have also tried MS Access with the same error.
Date fields are a problem since there are some dates not recognized (22.Okt.2009 and 01.Dez.2009) which were entered in Europe. I keep getting the error - [Lotus][ODBC Lotus Notes]Data value is not a valid date, time or timestamp.
I have tried writing in a CAST, CONVERT, To_Char but the driver doesn't seem to allow these to go through. Nor does it allow {fn xxxx}. Unles my syntax is wrong for NotesSQL.
Return to top
Print this page
