Connection failure.You must change the database setting - Access DB

[Anonymous]

Hi All,
I am getting below mentioned error message by using below mentioned steps
Error " Connection failure.You must change the database setting"
Steps:
1. Click on Metadata
2. Right click on DB connections, then create connections
3. Enter name as MyAccessDatabase and hit Next button at the bottom
4. Selected Access from DB Type drop down list
5. Leave blank for Login and Password fields
6. Click on Browse button to select a file (Ex: D:/MSAccess/MySampleDatabase.accdb)
7. By doing this String of Connection becomes "jdbc dbc river={Microsoft Access Driver (*.mdb)};DBQ=d:/msaccess/mysampledatabase.accdb"
8. Now when I hit Check button I got above mentioned error message.
Please let me know how should I proceed from here.
Thanks,
Jagmohan

[Anonymous]

First of all, did you checked your local ODBC setting in Windows it self. The ODBC bridge (that is what you actually use) depends on this.
I would try also using any other JDBC database tool (SQuirrel e.g.) if you can access the metadata with they connection.

[_AnonymousUser]

I have the same problem.
The interesting thing is that I get error only when setting up a connection with Talend Data Quality (Version 5.2.2.r99271)
I have aslo installed Talend Data Integration and this seems to work fine
I am connecting to a local MySQL instance.
Please advice

[Anonymous]

I have the same problem at Talend 5.3.1!
I am able to use any other database (mysql, sql, postgree) but with Access I can´t establish connection
Please, advices!!!

[Anonymous]

I have the same problem at Talend 5.3.1!
I am able to use any other database (mysql, sql, postgree) but with Access I can´t establish connection
Please, advices!!!

I tested and got the same problem in v5.3.1, can you please report a bug in our bugtracker?
Shong

[Anonymous]

Is there a resolution to this issue to date? Is there another connection to MDB preferred?

[Anonymous]

Am getting same error when trying to connect to local mysql from DI.
but its working fine from MDM and DQ.
Whether its a BUG ?
Please advice.
Regards,
Ashwini Ahire

[Anonymous]

Hi,
Could you please indicate the build version you're using? How did you get to the DB connection by Metadata or tMysqlxxx component in Talend DI?
Best regards
Sabrina

[Anonymous]

Como Puedo conectarme desde Talend un Una BASE DE DATOS que tengo alojada en un hosting

[_AnonymousUser]

Hi
I am having the same problem with 5.5.1, could it be my java isn't configured correctly?
I am getting the same error when attempting to add Access metadata.
does my Talend bit version need to be the same as my java bit version?
would appreciate help
many thanks