How do I allow Microsoft Access 2007 to read a CLOB in an Oracle linked table?

Posted on 2011-05-02
Last Modified: 2012-06-21
I am migrating an Access 2007 database to an Oracle 10g database as the backend. I am having issues converting an Access memo datatype to the Oracle equivalent, which to my belief would be a CLOB. The access memo data contains data over 4000 characters so a VARCAHR2 will not work in this instance. Access gives an error when trying to read the converted CLOBS.

How can I allow Access to read the data in the Oracle database.
Question by:kkusic1
    LVL 22

    Accepted Solution

    You must use the Oracle ODBC driver (supplier buy Oracle). The Microsoft ODBC supplied driver for Oracle does not work. It can be found in the Oracle Client software - ensure that you use the 32 bit client. - eirther Oracle 10 or 11.1 (not 11.2 as this ODBC driver was not certified for Windows last time I checked).

    LVL 12

    Expert Comment

    What error did you get? Can you post this?

    Below thread interesting to read;


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle PL/SQL syntax 4 30
    Show Balance 3 15
    Oracle Pivot 2 20
    Printing Problem 13 21
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now