Connection to an Access DB

Not applicable

Connection to an Access DB

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.
Not applicable

Re: Connection to an Access DB

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

Re: Connection to an Access DB

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?
Not applicable

Re: Connection to an Access DB

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.
One Star

Re: Connection to an Access DB

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
Not applicable

Re: Connection to an Access DB

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 ?
One Star

Re: Connection to an Access DB

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

Re: Connection to an Access DB

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

Re: Connection to an Access DB

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.
One Star

Re: Connection to an Access DB

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