1. Maggie Delaney
  2. PowerBuilder
  3. Thursday, 14 March 2024 12:16 PM UTC

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

 

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 14:45 PM UTC
  2. PowerBuilder
  3. # 1

If your PB app is 32 bits, then your client "SAP IQ Client Suite 16.0 sp08" should also be 32 bits. 

Comment
  1. Miguel Leeuwe
  2. Thursday, 14 March 2024 16:39 PM UTC
Maybe SAP IQ is not supported by Appeon. Look into supported databases in the documentation.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 14 March 2024 17:12 PM UTC
HI Maggie;

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
  1. Helpful
  1. Miguel Leeuwe
  2. Thursday, 14 March 2024 20:09 PM UTC
Officially JDBC is not longer available "out of the box", but can still be used following these instructions:



https://www.appeon.com/developers/get-help/knowledgebase/4434

regards
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.