Re: MS Access Memo Field

2003-11-26 Thread TINO SCHÖLLHORN


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]



MS Access Memo Field

2003-11-25 Thread Graham Lounder
Hey all,

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]