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
- 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.
-
Have you seen this post: Consuming an Access Database ?
Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch. -
Have you seen this post: Consuming an Access Database ?
Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.
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 -
The XML file looks like this
<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<?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 -
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.
There is also a section (video) about XML processing in Clover Quick Start Guide.
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. -
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.
There is also a section (video) about XML processing in Clover Quick Start Guide.
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.
This is a workaround for now -
Have you seen this post: Consuming an Access Database ?
Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.
Thanks for sharing
Please sign in to leave a comment.
Comments 6