"Problems in database writing"

maria_godric

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

haddock

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?

land

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