🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

"Problems in database writing"

maria_godricmaria_godric Member Posts: 20  Maven
edited May 2019 in Help
Hi,
I am trying to write my result in Access database.But I couldn't able to write even though  ODBC Bridge is available in my RM.I am getting the following error
"No suitable driver found for C:\Documents and Settings\ADMIN\Desktop The JDBC driver has thrown an SQLException. This may because of a lack of privileges, wrong table name or url and similar problems. Please note that some databases are case sensitive. Details are given in the message."


Here I am attaching my process.
<operator name="Root" class="Process" expanded="yes">
    <operator name="TextInput" class="TextInput" expanded="yes">
        <list key="texts">
          <parameter key="bmerge" value="C:\Documents and Settings\ADMIN\Desktop\mm"/>
        </list>
        <parameter key="vector_creation" value="TermOccurrences"/>
        <list key="namespaces">
        </list>
        <operator name="ToLowerCaseConverter" class="ToLowerCaseConverter">
        </operator>
        <operator name="TokenReplace" class="TokenReplace">
            <list key="replace_dictionary">
            </list>
        </operator>
        <operator name="StringTokenizer" class="StringTokenizer">
        </operator>
        <operator name="TermNGramGenerator" class="TermNGramGenerator">
            <parameter key="max_length" value="4"/>
        </operator>
    </operator>
    <operator name="ExampleSetTranspose" class="ExampleSetTranspose">
    </operator>
    <operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
        <parameter key="database_system" value="ODBC Bridge (e.g. Access)"/>
        <parameter key="database_url" value="C:\Documents and Settings\ADMIN\Desktop\dbase"/>
        <parameter key="username" value="sa"/>
        <parameter key="password" value="2iri46TWxdXwrAnA8XAlvg=="/>
        <parameter key="table_name" value="tab1"/>
    </operator>
</operator>

Can anyone help me.
Thanks
Maria
Tagged:

Answers

  • haddockhaddock Member Posts: 849  Guru
    As others have said, Ave Maria!

    While there is a DbaseReader for access files there is not a DbaseWriter, even there there are Database writers as well as readers for SQL heads. Does that help?
  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531   Unicorn
    Hi,
    how many attributes does the resulting example set have? Although the error message points in a single direction, there might be other underlying errors, causing it.

    Greetings,
      Sebastian
Sign In or Register to comment.