One Star

Error while creating database connection to MS Access Database file

Hi,
I am using Talend Open studio for data integration version 5.6.1
I am trying to create a database connection to MS Access MDB file and while doing that i am receiving this error. "Connection Failure. You must change the database settings."
Steps that i perform.
Metadata->Db Connection-> Right click on it-> create connection -> Provided name -> Next -> DB Type=Access -> DB Version= Access 2003 -> Blank login and password-> pointed the file location to my local C drive document directory -> Click on check and received this error.
Error image attached to the topic.

Error Details->
Connection failure. You must change the Database Settings.
  java.sql.SQLException: Data source name not found and no default driver specified
      at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1080)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:311)
      at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.runWithCancel(DatabaseForm.java:2335)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.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)


Please assist.
Thank You
Dharmit
9 REPLIES
Moderator

Re: Error while creating database connection to MS Access Database file

Hi Dharmit,
Make sure the database Access 2003 driver is available in your ODBC source Administrator.
What's your OS and JDK version?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error while creating database connection to MS Access Database file

Hi, I have Windows 7 Professional Sp1 64 bit and have JDK 7 update 71, Build 1.7.0_71-b14
Attached is the image for my ODBC Data Source Administrator for User DSN, System DSN and Drivers. Correct my if i am wrong, I think the Access driver is installed on the machine.
Please let me know if its missing.

Also could you provide me a link from where i can download the Access 2003 driver?
Thanks
One Star

Re: Error while creating database connection to MS Access Database file

Hi - I am also getting the same error. I am connecting to MS Access 2007 and am running with a *.mdb, *.accdb 32 bit driver (on a 64 bit windows 8.1 machine, Java V7).  This has previously worked until I had to uninstall and reinstall Talend.   On creating the connection, the driver connection string that was selected is jdbcSmiley SurpriseddbcSmiley Very Happyriver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=X:/Client Andino/Andino.accdb.  Can you suggest any solution?

One Star

Re: Error while creating database connection to MS Access Database file

If you're using Talend + Java 64 bits, you'll need to install Access Driver 64 bits
same for 32 bits (Im not sure)
Can you create an ODBC connection ?
One Star

Re: Error while creating database connection to MS Access Database file

Hi All,
I was able to solve this issue by running TOS_DI-win32-x86.exe which is 32 bit version of talend open studio rather than running TOS_DI-win-x86_64.exe which is 64 bit. I thought let me try it out and it works.
Thanks
Dharmit
One Star

Re: Error while creating database connection to MS Access Database file

Hi All,
I was able to solve this issue by running TOS_DI-win32-x86.exe which is 32 bit version of talend open studio rather than running TOS_DI-win-x86_64.exe which is 64 bit. I thought let me try it out and it works.
Thanks
Dharmit

be carefull when you export your job as a standalone job, you may need to specify the path of Java 32 bits in the bat file, or just change the Windows environment variable (I had this problem and it tooks me hours to solve it)
One Star

Re: Error while creating database connection to MS Access Database file

Hi All,
I was able to solve this issue by running TOS_DI-win32-x86.exe which is 32 bit version of talend open studio rather than running TOS_DI-win-x86_64.exe which is 64 bit. I thought let me try it out and it works.
Thanks
Dharmit

be carefull when you export your job as a standalone job, you may need to specify the path of Java 32 bits in the bat file, or just change the Windows environment variable (I had this problem and it tooks me hours to solve it)
If you have, Could you provide me Access 64 bit driver?
Thanks
Dharmit
Moderator

Re: Error while creating database connection to MS Access Database file

Hi,
Please see a related forum:https://www.talendforge.org/forum/viewtopic.php?id=16134.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error while creating database connection to MS Access Database file

Hi all
I was also able to solve this issue by running TOS_DI-win32-x86.exe.
thanks!