One Star

problem in the execution throw an odbc driver(type DB is paradox (.db)

in my work with talend I need to work with
a database paradox, for it
I created an ODBC data source, then I created a new job and a connection to the source
and I retrieve the schema (my desired table)
the job file contains a tDBInput that represent the table, tmap and a fileOUtputExcel
the problem is that I have this message after the execution:
connecting to socket on port 3976
connected
Exception in component tDBInput_1
java.sql.SQLException: Impossible d'ouvrir Paradox.net.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test2.hhhh_0_1.hhhh.tDBInput_1Process(hhhh.java:931)
at test2.hhhh_0_1.hhhh.runJobInTOS(hhhh.java:1539)
at test2.hhhh_0_1.hhhh.main(hhhh.java:1407)
disconnected
I did not understand where the problem exactly
and what is Paradox.net ??

please help me
1 REPLY
Community Manager

Re: problem in the execution throw an odbc driver(type DB is paradox (.db)

It seems that you don't have the ODBC drivers for Paradox installed. or maybe you have a write privilege issue as you need to extract data from Paradox?