Talend community forum / Connection to an Access DB

Adrien · 2008-03-10 12:19:12

Hello,

I have some troubles to connect Talend with My Access DB.
I use the wizard to do that, I indicates my DB file, but when I check the connection, I have this error message : "Connection failure. You must change the Database Settings.".

I use Talend Open Studio v2.3.1 and Access 2007.

Thanks.

Adrien · 2008-03-10 14:12:20

Nobody as successful configure Talend 2.3.1 with Access ?
Someone can help me please. I don't konw how to configure Talend.

Thanks.

cahsohtoa · 2008-03-10 14:24:36

I don't have any problem with access connexion in 2.3.1 but I use Access 2003
What is your file name? Do you use the .mdb?

Last edited by cahsohtoa (2008-03-10 14:25:33)

Adrien · 2008-03-10 14:32:52

I use .accdb. Access 2007 create this extention file.

I also find this error message when I try to execute a query :
in frensh : java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access] Impossible d'ouvrir la base de données '(Inconnu)'. Ce n'est peut-être pas une base de données que votre application reconnaît, ou le fichier est peut-être endommagé.
in english : java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access] Impossible to open the dabase '(Unknown)'. It's maybe a database which is not recognize by your application, or the file is damaged.

cahsohtoa · 2008-03-10 14:53:25

I'm not fully sure but I think this new format does'nt work with talend, maybe you can report the bug in the bugtracker

Adrien · 2008-03-10 14:58:03

OK, I will report the bug in BUGtracker.
But I have try with renaming the file in .mdb, and I have the same problem.

any idea ?

cahsohtoa · 2008-03-10 15:04:18

Maybe if you don't use some access 2007 adavanced setting you can save your database in mdb format and it will work.

Adrien · 2008-03-10 15:15:17

Thanks everybody, it's work.

I have save my database in the 2003 Access format and the connection is succefull.

Volker Brehm · 2008-03-10 21:23:28

I do not have access to Access 2007. But if it did not work with this version, please add a bug (or feature). Saving the database in a older version should only be a workaround.

vittirivizzik · 2012-02-20 11:58:08

Hi,

I have the same problem
i can't connect to my Access Database. I selected the Database but when i checked the connection an error message appear : error appear in 'Database configuration' page

when i clicked on details : [Microsoft][Pilote ODBC Microsoft Access] Ressources système insuffisantes
I use TOS-Win32-r67267-V4.2.3. OS = windows xp

Announcement

Unanswered posts

#1 2008-03-10 12:19:12

Connection to an Access DB

#2 2008-03-10 14:12:20

Re: Connection to an Access DB

#3 2008-03-10 14:24:36

Re: Connection to an Access DB

#4 2008-03-10 14:32:52

Re: Connection to an Access DB

#5 2008-03-10 14:53:25

Re: Connection to an Access DB

#6 2008-03-10 14:58:03

Re: Connection to an Access DB

#7 2008-03-10 15:04:18

Re: Connection to an Access DB

#8 2008-03-10 15:15:17

Re: Connection to an Access DB

#9 2008-03-10 21:23:28

Re: Connection to an Access DB

#10 2012-02-20 11:58:08

Re: Connection to an Access DB

Board footer