Connection to Pervasive SQL via ODBC -Error-

CloverDX Platform
1

Hello,

i have dowload the desktop trial version of CloverETL.
I try to connecxt to my Pervasive SQL v11 database via the your SUN ODBC driver.

The validation of the connection is valid.

If I want to go further e.g. META or SQl-Query i got the following error:
“[Pervasive][ODBC Client interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable”

May someone can help.

Regards
Andreas

2

Hello Andreas,
JDK odbc-jdbc driver is the basic universal jdbc driver and works on very base level only. You should always use the jdbc driver published by database provider or, the one, that is designed to use with given concrete database. So in your case, you should download the JDBC SDK from Pervasive and use this driver in your connection definition (see Database Connection Wizard).