locked
SQL Server ODBC Driver RRS feed

  • Question

  • Hi,

    I have the application use  DBMS SQ Server 2005 and ODBC to connect, but some clients don't work with bound parameters in subquery. In runtime, It returns SQL State error: 37000

    Please, help me!

    Thanks!

    Wednesday, September 14, 2011 9:59 AM

Answers

  • SQL State 37000 corresponds to syntax error. Please make sure that the value you specify for parameter is correct. For example, if date format on the computer is <month>/<day>/<year> but you specify <day>.<month>.<year> you'll get a syntax error.

    If you can't pinpoint the problem please post the source code and the values you are passing through these parameters.

    • Marked as answer by KJian_ Wednesday, September 21, 2011 7:37 AM
    Wednesday, September 14, 2011 4:26 PM