Compare the field types in your SQL Server databases on Dev and Production. Your production database field type may need modified.
Tony Gruen sfnetworks -----Original Message----- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 1:54 PM To: CF-Talk Subject: Client storage woes 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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