|
I am using a JET database and I get the following error:
Microsoft JET Database Engine error '80040e14'
Malformed GUID. in query expression
|
|
|
This error can usually be solved by changing some of your configuration settings- specifically, the gsSQLDateDelimiter and giSQLDateFormat which control how dates are communicated to the database. While our default configuration settings work with most installations, there are certain JET drivers that will not understand dates passed in this format. In most cases, you will want to set the gsSQLDateDelimiter to Chr(35) and the giSQLDateFormat to 2.
These settings can be found in the application database connection file (XXdb.asp) in version 3.0 and higher of XcAuction, XcClassified, XcDirectory and XcNews. In other applications, they may be found at the bottom of the configuration (the XXConfig.asp file in most applications, or else using the online configuration tool with XUD 1.x and XcClassified 2.x)
|
