# Connecting with Microsoft Access .mdb Databse

**URL:** <https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993>\
**Category:** CloverDX Platform\
**Created:** [January 2, 2012, 12:00am UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993 "2012-01-02T00:00:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![faldarod](https://avatars.discourse-cdn.com/v4/letter/f/97f17d/32.png) [@faldarod](https://forum.cloverdx.com/u/faldarod)\
**Post date:** [January 2, 2012, 12:00am UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/1 "2012-01-02T00:00:00Z")

</div>

Hallo,

I am having problems connecting to an local .mdb file.  
I have seen the following topics, but these didnt solve my problem.  
- [http://forum.cloveretl.com/viewtopic.php?f=4&t=5093](http://forum.cloveretl.com/viewtopic.php?f=4&t=5093)  
- [viewtopic.php?f=4&t=167](http://forum.cloveretl.com/viewtopic.php?f=4&t=167)

My problem is with making the Database connection.  
It doesn’t validate the connection and the following error

> [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The url ill input is

> jdbc:odbc:Driver={Microsoft Access Driver (\*.mdb)};DBQ=G:\Database.mdb

.

I have also included the database file.

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [January 2, 2012, 6:15pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/2 "2012-01-02T18:15:57Z")

</div>

Have you seen this post: [Consuming an Access Database](http://forum.cloveretl.org/viewtopic.php?f=4&t=4663) ?

Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.

---

<div class="post-metadata">

**Author:** ![faldarod](https://avatars.discourse-cdn.com/v4/letter/f/97f17d/32.png) [@faldarod](https://forum.cloverdx.com/u/faldarod)\
**Post date:** [January 2, 2012, 6:55pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/3 "2012-01-02T18:55:46Z")

</div>

> Have you seen this post: [Consuming an Access Database](http://forum.cloveretl.org/viewtopic.php?f=4&t=4663) ?
> 
> Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.
> 
> “dpavlis”

Yea i have already noticed that. In the 64 bit ofbc there isnt an access driver installed. I made a work around for it for so long. Made a xml file but now it seems not getting true, caused by metadata

---

<div class="post-metadata">

**Author:** ![faldarod](https://avatars.discourse-cdn.com/v4/letter/f/97f17d/32.png) [@faldarod](https://forum.cloverdx.com/u/faldarod)\
**Post date:** [January 2, 2012, 7:01pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/4 "2012-01-02T19:01:54Z")

</div>

The XML file looks like this

```auto
<Geheugenpoli1><Line><Naam>Client 176</Naam><PatientNr>2010176</PatientNr></Line><Line><Naam>Client 93</Naam><PatientNr>2010093</PatientNr></Line>

```

The XML Map looks like this

```auto
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="Geheugenpoli1" type="Geheugenpoli1Type"/>
  <xs:complexType name="LineType">
    <xs:sequence>
      <xs:element type="xs:string" name="naam"/>
      <xs:element type="xs:int" name="PatientNr"/>
    </xs:sequence>
  </xs:complexType>
  <xs:complexType name="Geheugenpoli1Type">
    <xs:sequence>
      <xs:element type="LineType" name="Line" maxOccurs="unbounded" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:schema>

```

So what kind of meta do i need to make?

I created the following

Line  
- String naam  
- String PatientNr

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [January 2, 2012, 7:54pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/5 "2012-01-02T19:54:50Z")

</div>

Hmm, what does this have to do with MS Access ? It looks like you want to parse some XML data.  
For this, use XMLExtract component (the fact that you have XML schema for your data will help) - see [XMLExtract reference in Clover doc](http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/xmlextract.html).

There is also a section (video) about [XML processing in Clover Quick Start Guide.](http://www.cloveretl.com/documentation/quickstart/working%5Fwith%5Fxml.htm)

In any case, you will have to create metadata carrying fields which you will be filling from the XML data - so your guess is correct. The video listed above shows all this.

---

<div class="post-metadata">

**Author:** ![faldarod](https://avatars.discourse-cdn.com/v4/letter/f/97f17d/32.png) [@faldarod](https://forum.cloverdx.com/u/faldarod)\
**Post date:** [January 2, 2012, 8:22pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/6 "2012-01-02T20:22:47Z")

</div>

> Hmm, what does this have to do with MS Access ? It looks like you want to parse some XML data.  
> For this, use XMLExtract component (the fact that you have XML schema for your data will help) - see [XMLExtract reference in Clover doc](http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/xmlextract.html).
> 
> There is also a section (video) about [XML processing in Clover Quick Start Guide.](http://www.cloveretl.com/documentation/quickstart/working%5Fwith%5Fxml.htm)
> 
> In any case, you will have to create metadata carrying fields which you will be filling from the XML data - so your guess is correct. The video listed above shows all this.
> 
> “dpavlis”

This is a workaround for now

---

<div class="post-metadata">

**Author:** ![henrymandy33](https://avatars.discourse-cdn.com/v4/letter/h/45deac/32.png) [@henrymandy33](https://forum.cloverdx.com/u/henrymandy33)\
**Post date:** [January 25, 2012, 12:57pm UTC](https://forum.cloverdx.com/t/connecting-with-microsoft-access-mdb-databse/993/7 "2012-01-25T12:57:28Z")

</div>

> Have you seen this post: [Consuming an Access Database](http://forum.cloveretl.org/viewtopic.php?f=4&t=4663) ?
> 
> Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.
> 
> “dpavlis”

Thanks for sharing