Options
Wrie Access: ODBC Driver Manager: data source name not found and no default
Contributor II
When I try to use Write Access to write to an Access database, I get the following error:
Database error occurred: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
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.
What is done to resolve this error?
I've tried specifying Access 2007 and Access 2003 files.
Not sure what to enter for a username or password since my databases don't use them.
I am running Windows 7 on 64-bit Intel.
Database error occurred: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
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.
What is done to resolve this error?
I've tried specifying Access 2007 and Access 2003 files.
Not sure what to enter for a username or password since my databases don't use them.
I am running Windows 7 on 64-bit Intel.
<operator activated="true" class="write_access" compatibility="5.2.003" expanded="true" height="76" name="Write Access" width="90" x="56" y="273">
<parameter key="database_file" value="c:\temp\RapidMiner.mdb"/>
<parameter key="table_name" value="p1"/>
<parameter key="overwrite_mode" value="append"/>
</operator>
1
Answers
I have the same problem but with a PostgreSQL database. Someone?