Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
0683p000009MEZu.png 0683p000009MEZz.png 0683p000009MERA.png
Labels (4)
1 Reply
Anonymous
Not applicable
Author

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?