On 2/18/10, Matthew Smith wrote: > I am getting an error in a query that does not happen with crystaltech. > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server > Driver]Invalid precision value
I am betting that a reputable hoster such as Crystaltech is not using ODBC for connections to MS SQL Server. Yet the error code indicates your local test environment does. Any particular reason for that? > The data type of the column is nvarchar(100). ODBC and native charsets are a match made in hell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
