Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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]
[SwaJime]: Ran into an interesting piece of code today ...
[SwaJime]: select name,status, status2 from __ where status & status < 13 and status2 & 16 <> 16

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2017-08-22 17:54 GMT
Find Nodes?
    Voting Booth?
    Who is your favorite scientist and why?

    Results (337 votes). Check out past polls.