Update fails on CF 7.0, works on CF 5.0

[jdeline]

I'm not sure what's going on. The UPDATE below works with CF5.0 with MS Access
ODBC, but fails with CF 7.0 with MS Access with Unicode. I first tried to make
the datasource on the 7.0 box just MS Access ODBC, straight out of the box, but
received the following error.
----------------------
Connection verification failed for data source: slm
java.sql.SQLException: Unable to retrieve error message from backend ODBC
Driver.
The root cause was that: java.sql.SQLException: Unable to retrieve error
message from backend ODBC Driver.
----------------------

reference is defined as long integer, action and issue are memo fields and the
rest are text.

Any ideas?


C:\Inetpub\wwwroot\cfdocs\CASLM\sendMail.cfm: line 67
65 : UPDATE incident SET status = '#status#',
severity = '#severity#', type = '#type#', todayDate = '#todayDate#',
66 : recipients = '#recipients#', action = '#currentAction#',
issue = '#currentIssue#'
67 : WHERE reference = #reference#

The resolved UPDATE statement:
UPDATE incident SET status = 'Degraded', severity = 'High Impact', type =
'Closed',
todayDate = '20060414165932', recipients = '2,5', action = 'Recharged the AC',
issue = 'Overheated server rack'
WHERE reference = 323232

[jdeline]

Problem resolved, sort of. Using the MS Access ODBC, rather than Unicode, works. Now my question is "Why?"

[SafariTECH]

Is the MS Access db actually created as a Unicode database?

By default, the server will use the default encoding suggested by the OS, which generally is not unicode in the case of Windows.

[Mountain Lover]

reserved words...type is a reserved word. Change the field name or
surround the reserved word in brackets [type]. The unicode driver is
much pickier.
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]