• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • How do I connect PowerBuilder2021+PowerServer2021 to IBM DB2/400 6.1 Version database?

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved How do I connect PowerBuilder2021+PowerServer2021 to IBM DB2/400 6.1 Version database?

  1. How-to
0
Votes
Undo
  1. Mason Park
    Mason Park
  2. PowerServer
  3. Thursday, 16 September 2021 07:21 AM UTC

Hi, we're looking for the way to connect PowerBuilder2021+PowerServer2021 to IBM DB2/400 6.1 Version database.

We successfully installed Informix 2.2.0.100 as database driver(from nuget.org) and filled the Database Configuration form. However, when we finally click on the Test connection... button, the cursor icon keeps its hourglass form indicating they are working on something and the message for the test connection result never shows up.

Is there any solution we can try to solve this problem or could you explain why the test connection doesn't work?

Any help would be appreciated.

Attachments (1)
db_connection_failing.png db_connection_failing.png
  1. Database
  2. PowerBuilder (Appeon)
  3. PowerServer
Application License
Silent installation of cloud app launcher
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 14:28 PM UTC
  2. PowerServer
  3. # 1

Hi Mason;

  This typically means that the IDE can not reach the DB server.

  Can you use another DB Tool that connects the same way to the DBMS to test if this works from the PB IDE machine?

Regards ... Chris

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 15:17 PM UTC
  2. PowerServer
  3. # 2

try installing a normal DB2 / informix client. I think the problem might be the "nuget" driver. Make sure it's a client with a version that complies with the Appeon supported drivers.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 16 September 2021 15:23 PM UTC
Informix native driver - Informix 7.x/8.x/9.x/10.x/11.x

from: https://docs.appeon.com/2017/server_configuration_guide_for_net/supported_database_drivers.html which is the 2017 information, maybe 2019 supports higher versions, but definitely, there's no mentioning of nuget v. 2.2.x
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 17 September 2021 08:47 AM UTC
PowerServer 2020 and older versions supported DB2. In 2022 version we dropped it. 2021 version uses NuGet packages. Older versions did not.
  1. Helpful 1
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 15:24 PM UTC
  2. PowerServer
  3. # 3

PowerServer 2021 does not support IBM DB2.  I'm sorry... you will need to stick with client/server, but you may want to try out the new PowerClient feature.

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 16 September 2021 15:45 PM UTC
IBM DB2 and Informix are two different databases, and since PowerServer didn't work out of the box so I assumed OP is using DB2.

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 16 September 2021 16:12 PM UTC
hmm, I guess you're right. Strange he tries to connect to DB2 using an informix driver then.

regards
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 16 September 2021 16:15 PM UTC
You are right. Let's see what OP says.
  1. Helpful
There are no comments made yet.
Mason Park
Mason Park Accepted Answer Pending Moderation
  1. Friday, 17 September 2021 01:53 AM UTC
  2. PowerServer
  3. # 4

Thanks everyone for your help! We tried the connection test again with more recent version of DB2 in the test environment and it worked. But since the actual production environment uses a much older version, guess we'll have to consider other options as well...

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 17 September 2021 07:35 AM UTC
Glad it worked Mason, but ... Just one doubt: is DB2 the same as Informix in your case?

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.