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

dcubed
dcubed New Altair Community Member
edited November 5 in Community Q&A
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"/>
          </operator>
Tagged:

Answers

  • JulioArriaga
    JulioArriaga New Altair Community Member

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