Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway?
I am getting error "Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Invalid connection string attribute - ERROR [08001] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server. Verify Host Name and Port Number.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: gatewayInstance."
What was done:- Installed the Progress 12.2 ODBC Driver driver, configured it and the connection test was successful;- During the connection, an attempt was made to fill in the Connection String field as shown in the example image available at https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...;- QDG is working correctly with Microsoft SQL Server.Could you help us with how to fill in these attributes?
Best Regards,Madson
Hi @Ranganath_DR
We were able to resolve this issue together with the customer.
The connection string for Progress OpenEdge is:HostName=IP;PortNumber=xxxx; DatabaseName=DBName;UserId=user;Password=pass;
Thanks for your support!
View solution in original post
Hi @madsoncamara ,
If connection is successful in ODBC driver, I would recommend to try the system DSN option and see if it works and note that Third-party ODBC drivers are supported on a best-effort basis.
https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...
System DSN
Choose one of the following:
Hi @Ranganath_DR,
The customer is still facing the problem, even with DSN configuration.
We have forwarded an ODBC driver from a similar environment that is working correctly with DB Progress and I am awaiting feedback from the customer.
Thank you for your support.
