|Perl Monk, Perl Meditation|
Re: Cannot insert into MS Access Memo field with DBIby simon.proctor (Vicar)
|on Jan 06, 2002 at 18:37 UTC||Need Help??|
In their infintite wisdom, Microsoft decided to make Memo fields like Blobs but with some additional bits and bobs on top.
What this means is that you have to connect to the database in a totally different way. This is not a fault of the DBI or Perl as it catches you out in ASP code just as easily. To solve this, as far as I can see, you should use Win32::OLE and build recordsets to access your data. If not, then you'll have to save your data to disk and reference the filename in the database.
If you want the memo fields, the code (in VBScript) is as follows:
I took that from here. Now looking at the constants stuff, we need to define adUseClient and keyset which we can set as :
So all we need to do now is create the recordset and the connection object. Full code
I did a quick test on my win2k machine with an access2000 database and it ran without error (note that this is a DSN less connection). I hope that gives you a starting point :)
Cheers - Simon