none
ODBC driver gives error while executing stored procedure when Money and SmallMoney has Currency Symbol. RRS feed

  • Question

  • Hello,

    We are migrating our application which was using SNAC OLEDB. Now it will use Microsoft ODBC Driver 11.

    Problem:

    1. Application calls the stored procedure using ODBC driver 11.
    2. Stored Procedure is having Money and SmallMoney as its input parameter.
    3. When these datatypes have currency symbol in its input( Ex. $123), ODBC driver is unable to handle it and it gives error "[Invalid character value for cast specification]" (SQL state 22018).

    Question:

    Is there any way by which ODBC driver can handle Currency Symbol? We are using ODBC API SQLBindParameter to bind Store procedure parameter and SQLExecDirect to Execute Stored procedure command.

    Regards,

    Seema

    Friday, February 12, 2016 10:19 AM

Answers

All replies