1. Rebecca Coleman
  2. PowerBuilder
  3. Wednesday, 27 May 2020 17:01 PM UTC

Hi

I am using PB 2019 using an ODBC connection to a DB2 database

I am having problems with DataWindow retrieves on a 64bit build. I have literally built the simplest application with a DataWindow, a DataWindow control on a window which retrieves the DataWindow using a retrieve statement

 

on a 32 bit deployment the data returns fine. When I deploy as 64 bit however, the data being returned has field values missing and data is getting shifted into different fields (corrupted).

what am I doing wrong?

thanks

Rebecca Coleman Accepted Answer Pending Moderation
  1. Thursday, 28 May 2020 09:08 AM UTC
  2. PowerBuilder
  3. # 1

Hi Chris

thanks for this, I think it is starting to point us in the right direction

I am definitely using a 64bit odbc (I have removed all my 32bit odbcs to make 100% sure)

I have got the Dba to run the application directly on our DB2 server and it works without any corruption of the data-window data.

looking at my client driver it looks like my driver is at a higher level than the server.

so we are going to see if we can patch our test server up to the same level as my client driver and see what happens! Fingers crossed you’ve solved this for us!!

I will let you know how we get on :)

 

kind regards

Rebecca

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 28 May 2020 16:19 PM UTC
Hi Rebecca .. thanks for the feedback & good luck on the patch! Please let us know how everything works out.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 27 May 2020 17:18 PM UTC
  2. PowerBuilder
  3. # 2

Hi Rebecca;

   It could be as a result of an improper 64 Bit ODBC driver for DB/2 setup or an mismatched DB Client driver version compared to your DB/2 server version.

Regards ... Chris

Comment
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.