Nick Bolton | 2008-02-18 23:31:39.0 | |
| Hi
I downloaded this new version, but got another problem: java.lang.RuntimeException: JdbcDataSource.importDefinition: java.sql.SQLException: Syntax error: Stopped parse at #1/1/95# And #12/31/95#)) GROUP BY Categories.CategoryName,Products.ProductName; I guess this time it is date/time conversion problem. Could you please give me some help on this or another version of driver? Thanks, Xiaoli Bie & Nick Bolton | ||
HXTT Support | 2008-02-21 07:16:58.0 | |
| It should be MS Access' #1/1/95# time format hasn't been supported by HXTT Access. You can try to modify your view sql in MS Access, or show us your view sql in MS Access. | ||
xiaoli bie | 2008-02-25 12:22:02.0 | |
| The query condition is like this
Between #01/01/1995# And #31/12/1995# which is the datetime format for MS Access. | ||