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
