To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57377 Issue #:|57377 Summary:|JDBC Errors updating numeric/money fields MS SQL |Server/Postgresql Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|sparg
------- Additional comments from [EMAIL PROTECTED] Fri Nov 4 10:45:00 -0800 2005 ------- I have encountered errors when updating numeric fields using JDBC drivers for Postgres 8; and now also the same error using Microsoft's JDBC driver for MS SQL server updating money fields. Error from SQL server as follows: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Disallowed implicit conversion from data type nvarchar to data type money, table 'traindb.dbo.stocktransactions', column 'stockvalue'. Use the CONVERT function to run this query. It seems OpenOffice is sending incorrect data types for numeric/money fields to JDBC drivers. This issue is probably the same as 51965 and 56921. So JDBC access is currently broken for business applications. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]