Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Accessing MS-Access memofield via DBI

by InfiniteSilence (Curate)
on Sep 12, 2005 at 12:22 UTC ( #491236=note: print w/replies, xml ) Need Help??

in reply to Accessing MS-Access memofield via DBI

Well, I'm not sure what DBI's issue is with MSAccess, but I use Win32::ODBC to write to memo fields in Access using a DSN without a problem:

my ($xsql) = new Win32::ODBC('VER2004R2'); $xsql->Sql($sql); $xsql->FetchRow(); my (%ahash) = $xsql->DataHash(); if (($ahash{Status} eq 'Solved') && ($ahash{'Assigned_to'} ne '') && ($ahash{'Resolved_by'} ne '') && ($ahash{'Verified_by'} ne '') ) { $sql = 'INSERT INTO tblBasicProblems_history ( PGNFIL +ENAME, '; $sql .= ' [Date], Description, Author, Status, Assign +ed_to, Resolution, '; ... $xsql->Sql($sql); ...

Celebrate Intellectual Diversity

Replies are listed 'Best First'.
Re^2: Accessing MS-Access memofield via DBI
by Anonymous Monk on Sep 12, 2005 at 12:40 UTC
    I do not use Win32::ODBC, because the Tool should connect to several database systems and writing plug-ins should also be easy. To simplify a cross-database-script it is very useful to use DBI, because you have unified methods for (nearly) all db-systems...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://491236]
Discipulus nevers ignores who is here since ever
[Eily]: IIRC 3% of all humans in history never ever died
[NodeReaper]: this is emotional, what did I do to deserve this?
[Discipulus]: Eily this percentage get higher everyday i suppose
Discipulus sometimes i'm here alone with you, bony brother
[Discipulus]: ok a Perl one: how approach the task of getting all distinct paths from the edge to a node of a pascal triangle (nobackwards)?

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (10)
As of 2018-03-19 10:49 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (239 votes). Check out past polls.