Wrie Access: ODBC Driver Manager: data source name not found and no default

dcubeddcubed Member Posts: 6 Contributor II
edited November 2018 in Help
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.

          <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"/>


  • Options
    JulioArriagaJulioArriaga Member Posts: 2 Contributor I

    I have the same problem but with a PostgreSQL database. Someone? :(

Sign In or Register to comment.