topic Re: Access 2010 database connection in Talend Studio

Access 2010 database connection

Anonymous — Thu, 22 May 2014 16:19:25 GMT

Hello everyone,
I am trying to create an access database connection but i can't succed doing it.
I got this error when trying to check the connection:
odbc driver manager: Source of data and found no default driver specified name
Any help plz?
thx alot

Re: Access 2010 database connection

Anonymous — Thu, 22 May 2014 16:49:38 GMT

Hi helronald,
Could you show us screen on how you set up this connection? Now i'm successfully connect talend with Access 2013.

Re: Access 2010 database connection

Anonymous — Thu, 22 May 2014 17:01:48 GMT

Hello and thx for the reply.
here are the screenshots:

Re: Access 2010 database connection

Anonymous — Thu, 22 May 2014 17:04:41 GMT

PS: I have access 2010 and talend 5.2.1 installed

Re: Access 2010 database connection

Anonymous — Thu, 22 May 2014 17:15:55 GMT

Hi,
Could you try again by changing to access .accdb file.

Re: Access 2010 database connection

Anonymous — Thu, 22 May 2014 17:19:26 GMT

Thx for the reply,
Yes i tried with a accdb file but i still get the same error

Re: Access 2010 database connection

Anonymous — Fri, 23 May 2014 02:13:09 GMT

Hi,
Please take a look at this
https://community.talend.com/t5/Design-and-Development/Database-connection-using-LDAP/td-p/101298
https://community.talend.com/t5/Design-and-Development/Microsoft-Access-JDBC-ODBC-Driver-problems/td-p/92784

Re: Access 2010 database connection

Anonymous — Fri, 23 May 2014 09:30:52 GMT

Hi helronald,
Could you connect to your Ms Access directly without talend? So far, we support for Ms Access ODBC bridge DB connection.
Best regards
Sabrina

Re: Access 2010 database connection

Anonymous — Fri, 23 May 2014 10:52:53 GMT

Hi and thx for the reply.
What do you mean by connecting directly to Ms Access plz?