0

Official Fog Creek Notice: MS Access support is being deprecated in FogBugz 8.0.

I'm running MS Access, and seeing this error message:

CCmd.asp - Data type mismatch in criteria expression. SQL: INSERT INTO SorterSetting (sKey, nValue) VALUES (?, ?) Params: SF 1: dUnknownProb 2: 0,5 1: dBackgroundStr 2: 1 1: cClue 2: 50 1: cClueStrings 2: 10 1: dExclusionRad 2: 0,1

What do I do?

flag

1 Answer

0

Workaround:

Microsoft Access databases have a problem working correctly on non U.S. locales.  Specifically, the interaction between the ',' decimal separator and the failure of Microsoft's Jet technology to correctly interpret a number, causes a SQL query error.  Currently the only workaround is to set the server to use '.' as the decimal separator, or upgrade to MySQL or SQL Server. 

link|flag

Your Answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.