Dear everyone,
I am having an issue creating a IQ db connection from our application. I do not wish to use ODBC connection (I tried it's working fine).
On my computer and user computer SAP IQ Client Suite 16.0 sp08 (64-bits) is installed. My PowerBuilder application is 32-bits. We are using PowerBuilder 2019 R3
My ini file connection is as per below:
Database=<database Name>
DBMS=ASE
LogID=<ID>
LogPassword=<Password>
ServerName=<server name>
autocommit=false
DbParm="Release='16'"
In my application, a new connection is created and information retrieve from the ini file.
When trying to connect I am getting now this error message:
Error connecting to Database. Error Text: Error loading client library DLLs. Unable to connect to server.
While using ODBC with the same information as per my ini file, it is working. For internal reason I need to avoid to use ODBC.
Can someone help me figure that out? point me to the right direction etc?
Many thanks.
Best regards,
Laurent
SyBase IQ has been "unofficially" supported in PB since way back in the version 11.x timeframe - but that being said - only via JDBC or ODBC. It's still the same today in Appeon PB but JDBC is no longer an option. You can only now use ODBC but you're also at the merci of the IQ ODBC driver comparability implementation.
JDBC: https://www.cdata.com/kb/tech/sybaseiq-jdbc-powerbuilder.rst
ODBC: https://www.cdata.com/kb/tech/sybaseiq-odbc-powerbuilder.rst
Regards ... Chris
https://www.appeon.com/developers/get-help/knowledgebase/4434
regards