Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"Problems in database writing"
maria_godric
Member Posts: 20 
Maven
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
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:
0
Answers
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?
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