[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1494
  • Last Modified:

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

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.
0
kkusic1
Asked:
kkusic1
1 Solution
 
Kelvin SparksCommented:
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).

Kelvin
0
 
danishaniCommented:
What error did you get? Can you post this?

Below thread interesting to read;
http://forums.oracle.com/forums/thread.jspa?threadID=541968&tstart=225

HTH,
Daniel
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now