Did you have ColdFusion create the tables on your production server when switching to ODBC client storage, or did you import them from the dev box?
If you didn't have CF create the tables, it's possible you selected an incorrect datatype. Joseph DeVore VeloxWeb Technologies -----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
