topic Re: Connection to an Access DB in Talend Studio

Connection to an Access DB

_AnonymousUser — Sat, 16 Nov 2024 14:26:08 GMT

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.

Re: Connection to an Access DB

_AnonymousUser — Mon, 10 Mar 2008 13:12:20 GMT

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

Re: Connection to an Access DB

Anonymous — Mon, 10 Mar 2008 13:24:36 GMT

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?

Re: Connection to an Access DB

_AnonymousUser — Mon, 10 Mar 2008 13:32:52 GMT

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: 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: Impossible to open the dabase '(Unknown)'. It's maybe a database which is not recognize by your application, or the file is damaged.

Re: Connection to an Access DB

Anonymous — Mon, 10 Mar 2008 13:53:25 GMT

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

Re: Connection to an Access DB

_AnonymousUser — Mon, 10 Mar 2008 13:58:03 GMT

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 ?

Re: Connection to an Access DB

Anonymous — Mon, 10 Mar 2008 14:04:18 GMT

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

Re: Connection to an Access DB

_AnonymousUser — Mon, 10 Mar 2008 14:15:17 GMT

Thanks everybody, it's work.
I have save my database in the 2003 Access format and the connection is succefull.

Re: Connection to an Access DB

Anonymous — Mon, 10 Mar 2008 20:23:28 GMT

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.

Re: Connection to an Access DB

Anonymous — Mon, 20 Feb 2012 10:58:08 GMT

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 : Ressources système insuffisantes
I use TOS-Win32-r67267-V4.2.3. OS = windows xp