----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:50 PM Subject: RE: 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. > > I'd look at these things: > > 1. Is the data schema exactly the same for both development and production > databases for the CDATA and CGLOBAL tables? Unless you created the data > schema manually, this shouldn't be a problem. > I had CF create the tables. > 2. In your ODBC datasource configuration in the CF Administrator on the > production server, did you enable the "Long Text Retrieval Settings" option? > I didn't - I changed the setting but it made no difference. > 3. Do you have different versions of MDAC on your two servers? You can find > out which version you have on each with the MDAC Component Checker, > available at http://www.microsoft.com/data/. > OK, I'll check that. Thanks, Howie > My money is on number 2. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
