Our main web server has a registry that is huge because of the CF client storage. So, I decide to store client data in a SQL db. I can get this to work fine on my development server but when I try to do the same thing for the production server I get a SQL error when accessing pages:
ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. I have no idea why this happens on our production server. Both production and test servers are CF5. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server <<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>> http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
