Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

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]: marto also Re^2: Catalyst:: Dispatcher - usage of expand_actions has signature polemic, and yesterday was quoted in CB
[marto]: Discipulus concerned partys should report things. as tye mentioned in his post (linked in the other thread from yesterday) there is an approach and strategy for such things

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (8)
As of 2017-06-23 08:46 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (538 votes). Check out past polls.