---------- Forwarded message ----------
From: Claus Kick <[email protected]>
Date: 2011/7/7
Subject: Re: MS Access Update Memo Field with 750 characters
To: Huub Peters <[email protected]>
> Hi,
> It's been ages since I've worked with Access (or Win32 for that matter) but I
> remember "LongReadLen" was the magic word.
> (Even though DBI docs says it's for reading only, as I recall, it worked for
> getting writing to MEMO fixed)
>
> my $dbh = DBI->connect('DBI:ODBC:driver=Microsoft Access Driver
> (*.mdb);dbq=file.mdb') or die $DBI::errstr;
> $dbh->{LongReadLen} = 20000;
>
> More solutions here but notice the last post which says the same as I
> suggested:
> http://www.perlmonks.org/?node=Cannot%20insert%20into%20MS%20Access%20Memo%20field%20with%20DBI
>
> Cheers,
> Huub
Hello,
thanks for the pointer - I have read that myself and tried it:
$dbh->{LongReadLen} = 65000 (max field length IIRC);
to no avail.
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
