Answered
Malformed GUID in hosting migration
I am moving a site from a Win2k3 server running IIS6, CF7 and
using an MS Access database to new hosting provider. I'm using
their Windows Hosting option so I can just set up the access
datasource and move the code, but have run into an error I have
been unable to solve after hours of googling. Any help?
Malformed GUID. in query expression 'sdate <= #03-15-2008# AND edate >= #03-15-2008# OR { fn MONTH(sdate)} = 3 AND { fn DAYOFMONTH(sdate)} = 15 AND recur = true'.
I cut up both halves of the query and was able to isolate it down to having something to do with the MONTH and DAYOFMONTH functions. This code works just fine on the old server. Seems like standard enough SQL, what would the new host be doing to cause these functions to error?
Malformed GUID. in query expression 'sdate <= #03-15-2008# AND edate >= #03-15-2008# OR { fn MONTH(sdate)} = 3 AND { fn DAYOFMONTH(sdate)} = 15 AND recur = true'.
I cut up both halves of the query and was able to isolate it down to having something to do with the MONTH and DAYOFMONTH functions. This code works just fine on the old server. Seems like standard enough SQL, what would the new host be doing to cause these functions to error?
AdChoices