locked
implicit conversion of nvarchar to money is not allowed RRS feed

  • Question

  • i m using SQLHelper to insert data in database...

    i have some parameters that are of type money.

    i m passing "0.00" to it and then i m 

    writing 

    SqlHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "cotica_Insert", parameter);

     

    here i am getting error 

    implicit conversion of nvarchar to money is not allowed

    but the same stored procedure with same parameters on different server works fine.

     

    can anyone proivide me with the solution.

     

    Regards,

    Kuldeep


    Regards Kuldeep Gupta
    • Moved by Paul Zhou Friday, March 25, 2011 5:21 AM off-topic (From:.NET Base Class Library)
    Friday, March 18, 2011 7:45 AM

All replies

  • Your servers may have different regional settings. So comma and dot have different meaning in them. You may check the regional settings on the SQL server instance.

     

    Good Luck


    ...
    Saturday, March 19, 2011 4:42 PM
  • Hi Kuldeep,

     

    Welcome to the MSDN forum!

     

    I suggest that you can post a thread in SQL Server Forum. There are more experts in that forum.

     

    And I’d like to move this thread to off-topic since the problem is not supported in BCL forum here.

     

    Thank you for your posting and understandimg.


    Paul Zhou [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    Monday, March 21, 2011 3:18 PM