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,
Is there any success after restarting your studio?
Best regards
Sabrina

[Anonymous]

Hi,
  Still the problem persists.

[Anonymous]

Hi,
I'm getting the same error:
"connection failure. You must change the database setting"
While trying to connect to Microsoft SQL Server (from Metadata->DBconnection)
Do I need to add some jars? Talend doesn't support this database automatically?
Thanks

[Anonymous]

Hi danny,
Is there any more error message about this connection issue? Can you successfully connect your Microsoft SQL server through client without using Talend Tool?
Talend Studio  requires specific third-party Java libraries or database drivers (. jar  files) to be installed to connect to sources and targets. Those libraries or drivers, known as external modules, can be required  by some of Talend components  or by some connection wizards or by both . Due to license restrictions,  Talend  may not be able to ship certain external modules within  Talend Studio .
Best regards
Sabrina

[Anonymous]

Thank you Sabrina for your fast reply,

Attached please find the full error message.
I tried to connect to both SQL Server and a local SQL Express. Both returned the same error. I can connect to both thru client (Microsoft SQL Server Management Studio).
Do you know if the necessary .jar files for Microsoft SQL Server are included in Talend? If not, which .jar files are needed?

Thanks
error_message.pdf_20160722-0418.pdf

[Anonymous]

Hi  danny_hal,

 Unknown server host name"xxx"

From your error message, there is something wrong with you DB connection parameter.
Could you please show us your DB connection setting screenshot?
For  necessary .jar files  for Microsoft SQL Server, please take a look at documents about:
TalendHelpCenter:Identify required external modules

TalendHelpCenter:Install external modules
Best regards
Sabrina

[Anonymous]

can somebody help how can I setup connection between Sql Server and talend. in my local system

[Anonymous]

I am getting same error  while connecting to postgresql database. 

[Anonymous]

Hello,

What's the postgresql database version are you using? On which talend build version you got this connection failure?

Best regards

Sabrina

[Anonymous]

Hey,

Please give some solution to following error message,

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:316)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4138)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2588)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
... 9 more
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3307)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1985)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1911)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
... 21 more

Thank you