Ms Access Database Connection

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hi All,
I'm trying to create a graph that extracts data from a Ms Access Database.
I created a Metadata with url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Database.mdb",
then, when I clicked next I got the following error message:
[Microsoft][Controlador ODBC ]Función opcional no implementada.
In English is someting like: [Microsoft][ODBC Microsoft Access Driver] Optional feature not implemented.
What I need to do? Someone can help me?
Thank you for your help!

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  That is probably correct. One way to go round it is to create metadata description by hand. Clover will complain about missing meta info from the driver but should be able to run the query.
  
  Nonetheless we will check MS Access interoperability and let you know.
  
  David.
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  I think that's what I'll have to do (manually create the CloverETL metadata description) from the MS Access table definitions.
  
  I was going to search for some other JDBC drivers to try (instead of the sun ODBC-JDBC bridge) to see if some other driver could extract the table definition meta information from MS Access. Has anyone tried different drivers to do this? Would I be wasting my time pursuing other drivers?
  
  thanks
  
  cliff
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  I have run into the same problem.
  I think it may be because MS Access cannot return the meta information required to define the table schemas -
  Can someone confirm this suspicion?
  
  thanks
• 

  dpavlis

  • December 29, 2011 11:40

  0

  Comment actions Permalink

  See related topic for some more info.

Please sign in to leave a comment.