topic Re: Check sqlite database connection in Talend Studio

Check sqlite database connection

Anonymous — Thu, 31 Oct 2013 09:29:40 GMT

Hello,
I want to create a new sqlite database connection or check an existing connection. After the input of the filename i try to check the connection with the button "Check". I got the message: "The file ... is invalid or doesn' exist." But the file exists and works. Also the jobs that use the connection works fine. Why the check button doesn't work?
Thanks in advance.
Marcus

Re: Check sqlite database connection

Anonymous — Fri, 01 Nov 2013 01:57:44 GMT

Hi,
What's the talend build version are you using? Does it repro on another version? Could you please paste your DB connection screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina

Re: Check sqlite database connection

Anonymous — Tue, 19 Nov 2013 08:02:27 GMT

Are there any spaces in the path to the file? I've noticed that for some connections, a space in the path still makes it fail the connection check, but it will work fine in the job itself.

Re: Check sqlite database connection

Anonymous — Wed, 30 Jul 2014 07:46:47 GMT

Hi
I am also facing issue with connection with SQLite DB.
I am using TOS 5.4.2.
Can I make SQLite connection an if possible how can I do it?
Thanks

Re: Check sqlite database connection

Anonymous — Wed, 30 Jul 2014 08:22:18 GMT

Hi Diwate,
Did you also face the error "The file ... is invalid or doesn' exist." when check SQLite DB connection with the button "Check"?
Best regards
Sabrina

Re: Check sqlite database connection

Anonymous — Wed, 24 Sep 2014 15:37:13 GMT

Hi evrybody,
I need to create an SQLite connexion : what I need to indicate in the section File of configuration Table.
Thanks

Re: Check sqlite database connection

Anonymous — Thu, 25 Sep 2014 08:25:37 GMT

Hi DjefelMERIEM,
Are you looking for component TalendHelpCenter:tSQLiteInput and TalendHelpCenter:tSQLiteConnection?
Best regard
Sabrina

Re: Check sqlite database connection

Anonymous — Thu, 25 Sep 2014 12:13:12 GMT

Hi Sabrine,
I am using theses tow componenet , but I want firstly to configure a database connexion in the metadata : When I configure the connexion in the metadata I have an error : The file is invalid or not exist.
Thanks

Re: Check sqlite database connection

Anonymous — Fri, 26 Sep 2014 04:10:28 GMT

Hi DjefelMERIEM,
Can you connect to sqlite database by client successfully without using Talend tool?
Best regards
Sabrina

Re: Check sqlite database connection

Anonymous — Fri, 26 Sep 2014 10:07:27 GMT

Hi Sabrina,
Yes the database sqlite is opnning with sqlite client.
Thanks

Re: Check sqlite database connection

Anonymous — Fri, 26 Sep 2014 16:25:55 GMT

Hi Sabrina,
I find the problem : the name of the file includes space.
Actually I establish the connexion but when I try to retrieve Table schema : talend doesn't find any tables, while when I use a SQLite Client I can see my six tables.
Have you any ideas?
Thanks

Re: Check sqlite database connection

Anonymous — Tue, 18 Aug 2015 13:39:01 GMT

Hi Sabrina,
I find the problem : the name of the file includes space.
Actually I establish the connexion but when I try to retrieve Table schema : talend doesn't find any tables, while when I use a SQLite Client I can see my six tables.
Have you any ideas?
Thanks

Hi DjefelMERIEM,
have you resolved this problem?