ESS / ODBC / SQL Server access and Number data type

Discussion created by phochstr on Jul 23, 2012



We try to use ESS to communicate with a SQL Server 2005 database. Sometimes, the connection (or the queries running over it) works flawless, at other times, we get an error that we have "Invalid Syntax near ','", usually with something like ",00" being shown as the location of the problem.


I think that FileMaker formats numbers with decimal digits even if they are just integers - who's to tell with an imprecise format like "number". In a normal SQL statement, the correction would be a simple formatting or string manipulation issue, but with ESS?


Any ideas on how to get rid of this problem?


This whole thing happens on FMS 11.0.3 on a Windows machine.


Thanks, Peter