I had CF create them. Howie
----- Original Message ----- From: "Joseph DeVore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:41 PM Subject: RE: Client storage woes > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
