🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Problems in database writing"

User: "maria_godric"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "haddock"
    New Altair Community Member
    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?
    User: "land"
    New Altair Community Member
    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