I am trying to map some string values into a SQL 2000 DB. I am using the execSQL service to do the insert how it keeps erroring out with the following error message. There are two fields in the DB that are “money” datatypes. The $dbParameterTypes in the execSQL service is passing the values in as “varchar”. What other parameter types can I use so that these values go in properly?
Disallowed implicit conversion from data type nvarchar to data type money, table ‘dbo.tblInvoice’, column ‘InvoiceTotal’. Use the CONVERT function to run this query.