That did it. Set up a regular sql server datasource and it worked.
Thank you so much. Just out of curiosity, when should I use nvarchar as opposed to varchar? On Thu, Feb 18, 2010 at 12:20 PM, Jochem van Dieten <[email protected]>wrote: > > 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:330884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
