> 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
