Thanks, that was the problem. I thought I had tried this earlier but I guess not.
Cheers, Graham -----Original Message----- From: news [mailto:[EMAIL PROTECTED] Behalf Of TINO SCH�LLHORN Sent: November 26, 2003 4:14 AM To: [EMAIL PROTECTED] Subject: Re: MS Access Memo Field "Graham Lounder" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hey all,Hi, as I can see you only have to set the data-type in your repository.xml of the memo-field to LONGVARCHAR. I have had the same problem, but now it is running fine. Tino > > I'm trying to save a string greater than 255 characters to a MS Access memo > field with no luck. I'm getting the following error: > > java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]String data, > right truncated (null) > > I've done some search on the internet and it seems this is a problem without > many solutions. I did notice that this was suppose to be fixed in rc4. I > did read that someone said that it might have something to do with the > autocommit setting? > > Any Ideas? > > Graham > > ======================================================================== > Graham Lounder - Java Developer > CARIS Spatial Components Division > [EMAIL PROTECTED] > Phone: (506) 458-8533 > Fax: (506) 459-3849 > ======================================================================== > NO BINDING CONTRACT WILL RESULT FROM THIS EMAIL UNTIL SUCH TIME > AS A WRITTEN DOCUMENT IS SIGNED ON BEHALF OF THE COMPANY. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
