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]

Hi,
I am having the same problem with Talend Open Studio for Data Quality v5.6.2 while trying to connect to an excel file. Can someone please solve this problem? Thanks.

[Anonymous]

I am using Talend DI 5.2. When I am trying to connect to postgreSQL, I'm getting the below error:
"Connection failure. You must change the Database Settings."
Could you please help me in resolving the issue.
Thanks in advance,
Thrilok.

[Anonymous]

  I am facing same issue while connecting Remote Oracle database from my Talend Enterprise DI(ver 5.6.2).I am able to connect same database using Talend DI open studio but not from Enterprise DI.Please suggest some resolution.

[Anonymous]

Hi adas_talend,
Did you set up your DB connection in metadata? What's the error message you are getting? jdbcODBC driver is missing? Could you please also post your error message into forum?
Best regards
Sabrina

[Anonymous]

Hi,
  I am using metadata manager.Please find attached screenshot of the error I am facing.

[Anonymous]

Hi,
  Please find attached screenshot of the error.I am using metadata to set up the oracle connection.

[Anonymous]

Hi adas_talend,
It seems that the screenshots didn't come through (any issue with the upload image feature?).
Please drop the image directly in the editor window after clicking "upload" button.

Best regards
Sabrina

[Anonymous]

Thanks for the suggestion.Please find attached error screenshot.

[Anonymous]

Hi adas_talend,
Have you already checked document about:https://help.talend.com/search/all?query=Configuring+the+Studio&content-lang=en?
Did you install and place required external jar in folder <StudioPath>/lib/java?

Best regards
Sabrina

[Anonymous]

Hi Sabrina,
  I am using  database connection wizard in which clicking 'check' button takes me to the details of Jar files that needs to be installed for the specified database settings.In this case it is Oracle 12 with Sid option.I have used download and install option from the window in which details of Oracle connectivity related jar file got downloaded and installed in the following path.
D:\Talendinstallation\studio\configuration\lib\java
Not sure anything else I have missed.Please suggest.