Re: ODBC probelms when connecting to MSSQL

On Thu, 2007-05-31 at 10:20 +0100, Robert Boardman wrote:

> dbd_error: SQL-42000 (native 257): [DataDirect][ODBC SQL Server
> Driver][SQL Server]Implicit conversion from data type varchar to money
> is not allowed. Use the CONVERT function to run this query. (SQL-42000)

I've reported this behaviour before ( twice actually ). The answer both
times was that this is SQL Server's problem, and that it's just being
difficult and not doing the conversion itself. A workaround is to
convert all your 'money' columns to 'decimal' columns, but beware ...
this seriously screws up MS Access, which can't handle the 'decimal'
column type, and treats it as varchar. There are probably other
problems too. Do a backup before converting anything.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au