I cannot connect to ODBC (driver: Pervasive ODBC Interface) via direct access
I cannot connect to ODBC (driver: Pervasive ODBC Interface) via direct access. I get the following error message:
‘Status(StatusCode=‘Internal’, Detail="Command testconnection returned non-success: Error message: Please check the values for Username‘ Password’ Host and other properties. Description: Specified driver could not be loaded - ERROR [IM003] Due to system error 1114: A DLL initialisation routine failed. (Pervasive ODBC Interface, C:\Program Files\Actian\PSQL\bin\odbcci64.dll) the specified driver could not be loaded.")’
When I test the created data connection in ODBC System-DSN with the driver (Pervasive ODBC Interface) this is successful.
Two further connections 1x ODBC (SQL Anywhere 16) + 1 x Microsoft SQL Server have already been successfully set up via the Data Gateway on the same server.