Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: Accessing MS-Access memofield via DBI

by marto (Bishop)
on Sep 12, 2005 at 12:21 UTC ( #491235=note: print w/replies, xml ) Need Help??

in reply to Accessing MS-Access memofield via DBI


You need to set DBIs LongReadLen() attribute.
Have a read a the the documentation.
Try something like:
!/usr/bin/perl use strict; use warnings; use DBI; my $dbh = DBI->connect('DBI:ODBC:driver=Microsoft Access-Treiber (*.md +b);dbq=db1.mdb',user,pass); $dbh->{'LongReadLen'} = 6000; # For have a maximum of 6000 chars... #... and so on....

Hope this helps,


Replies are listed 'Best First'.
Re^2: Accessing MS-Access memofield via DBI
by Anonymous Monk on Sep 12, 2005 at 12:34 UTC
    The LongReadLen attribute is not for inserting values (from documentation: The LongReadLen attribute only relates to fetching and reading long values; it is not involved in inserting or updating them.)

      Thanks for pointing out my brain burp of the day.
      InfiniteSilence and holli have both replied to the OPs first post with solutions.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://491235]
[erix]: Tanktalus home node has one
[stonecolddevin]: erix thanks mate
[stonecolddevin]: also lol @ "I stomped a crap"
[stonecolddevin]: Disciplus i was just amazed he's returned after the thorough stomp that BrowserUk and several other monks gave him for spreading crap info
[stonecolddevin]: i will admit i find the responses to his threads incredibly entertaining
[stonecolddevin]: erix what is this wizardy? there's no sound for me :-(
[stevieb]: he comes and goes every few years.
[erix]: stonecolddevin: oh? Don't know, it works for me

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2017-06-22 20:48 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (529 votes). Check out past polls.