Yep that is it. I had not installed them on my production machine thinking 5 is due out and sometimes they mess other things up. Like Begin transaction on my server version with all the FTF's locks the database so one of the fixes broke that.
Changing the type to TEXT did the trick and 5.0 should be around the corner. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "Scott Cadillac" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 23 Jul 2002 11:18:13 -0700 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: [OT] SQL server update problem > > Hi Dan, > > By Fast Fix on your development Server - do you mean FTF? > > Because the FTF 47 does contain a fix for the 255 field limit, which is > probably why it works on your Dev Server and not at the client site. > > From: http://www.witango.com/installers/ftf47/fixes.html > > "Corrected a problem with column lengths limited to 255, current limit is > 4000" > > WARNING: "This FTF is freely available to Tango2000 customers with the > understanding that it has not been fully tested to the extent a Service > Pack release would be tested. As such, an FTF build is not recommended > for use on a production site unless it provides a solution to a critical > problem." > > Hope this helps. Cheers... > > Scott Cadillac > http://xml-extra.net > [EMAIL PROTECTED] > > http://witango.org > [EMAIL PROTECTED] > > > ----- Original Message ----- > From: "Dan Stein" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 10:20 AM > Subject: Re: Witango-Talk: [OT] SQL server update problem > > >> Nope they are the same on the development machine and the one here. >> Besides the fact the there are some Fast Fixes applied to tango here the >> only difference is the updated version of SQL 2000 there. >> >> >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >>> From: Troy Sosamon <[EMAIL PROTECTED]> >>> Reply-To: [EMAIL PROTECTED] >>> Date: Tue, 23 Jul 2002 11:05:47 -0600 >>> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> >>> Subject: RE: Witango-Talk: [OT] SQL server update problem >>> >>> Check the "itemBufferSize" setting in the Tango server configuration. > I >>> think it is stored in the t3server.ini file. >>> >>> Troy Sosamon >>> >>> ===== Original Message from [EMAIL PROTECTED] at 7/23/02 9:44 am >>>> At my clients they update the SQL server 2000 so they are running > 8.00.534 >>>> >>>> I am running 8.00.194 >>>> >>>> I have long very long text field sometimes 2,000 characters that I am > trying >>>> to update. >>>> >>>> The import of the data went fine >>>> >>>> When I do the update here it also works fine. >>>> >>>> But there it gets a Right truncate 22001 error. >>>> >>>> The column is a varchar 3000 >>>> >>>> I had once had it set to text but it seemed to truncate the imports > then. >>>> >>>> What can I do to make the update work. >>>> >>>> Dan >>>> -- >>>> Dan Stein >>>> Digital Software Solutions >>>> 799 Evergreen Circle >>>> Telford PA 18969 >>>> Land: 215-799-0192 >>>> Mobile: 610-256-2843 >>>> Fax 413-410-9682 >>>> FMP, WiTango, EDI,SQL 2000 >>>> [EMAIL PROTECTED] >>>> www.dss-db.com >>>> >>>> >>>> > ________________________________________________________________________ >>>> TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] >>>> with unsubscribe witango-talk in the message body >>> >>> > ________________________________________________________________________ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >>> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
