The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
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?