My production server has 2.5.1 and the dev server has 2.6. Would you recommend upgrading to 2.6 or 2.7?
Thanks, Howie ----- 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. > > 2. In your ODBC datasource configuration in the CF Administrator on the > production server, did you enable the "Long Text Retrieval Settings" option? > > 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/. > > My money is on number 2. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
