1. Jonathan Meltzer
  2. PowerBuilder
  3. Friday, 16 November 2018

 I have migrated code from PB 10.5 to PB 2017R3, and the migration went fine - no errors.  Now I am building the code as a 64-bit pCode application, and the build is fine, but when I do a database connection in the app (using OLE DB), I get a message that OLE DB is not supported in my current installation.  I have the PBOLE170.DLL file with the other DLLs in the application directory - what else do I need to do for the app to be able to make an OLE DB connection?

Thanks,

Jonathan

Edited to change to a critical issue, as we need to have a way to connect to SQL Server with our 64-bit application.

Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

The SNC driver should work, it is less buggy than the OLE driver and is available in 64bit.

Comment
There are no comments made yet.
  1. Tuesday, 11 June 2019
  2. PowerBuilder
  3. # 1
Joseph Vendra Accepted Answer Pending Moderation
0
Votes
Undo

Sorry to tag on this,

 

We have clients also in the same boat and we found no PBOLE19.DLL x64 version available for PB 2019 GA 2082 release.

 

 

Comment
There are no comments made yet.
  1. Tuesday, 11 June 2019
  2. PowerBuilder
  3. # 2
Ken Guo Accepted Answer Pending Moderation
1
Votes
Undo

Hi Jonathan,

If your PB application is deployed as an 64bit application, then it doesn’t support OLE Microsoft OLE DB (SQLCA.DBMS =’OLE DB’). Currently there is no plan to support it either.
We suggest that you use SNC SQL Native Client as Julie mentioned, which is SQLCA.DBMS=’SNC SQL Native Client(OLE DB)’. Or you can use ADO Microsoft ADO.Net (SQLCA.DBMS =’ADO.Net’).
If you plan to use SNC SQL Native Client, please remember to change your PB code to use SQLCA.DBMS=’SNC SQL Native Client(OLE DB)’.

Regards,
Ken

Attachments (1)
Comment
There are no comments made yet.
  1. Tuesday, 20 November 2018
  2. PowerBuilder
  3. # 3
Jonathan Meltzer Accepted Answer Pending Moderation
0
Votes
Undo

Thank you for the response!  I am coding an app that will be distributed to all of the users in our company (about 800).  Would all of them have to have SNC installed as well, or do I just need it installed on the machine where the app is built and include the pbSNC170.dll in the distribution?

Comment
Sadly, there is no OLE-DB support currently in the 64bit PB world. However, I'll check with Engineering to see if its on their ToDo list.
  1. Chris Pollach
  2. Monday, 19 November 2018
Hi Jonathan;

Appeon Engineering came back to me this morning and stated that they will look into the support for 64bit OLE-DB after this next release (PB2018). No concrete promises at this time, but they will consider your request on their ToDo list.

Regards ... Chris
  1. Chris Pollach
  2. Tuesday, 20 November 2018
Thank you for following up on that! That would be great news. In the meantime, I am building a 32-bit application so that I can use OLE DB. I have tried the setups with SNC and ADO, and they did not work for our scenario.
  1. Jonathan Meltzer
  2. Tuesday, 20 November 2018
There are no comments made yet.
  1. Monday, 19 November 2018
  2. PowerBuilder
  3. # 4
Julie Jiang @Appeon Accepted Answer Pending Moderation
0
Votes
Undo

Hi Jonathan,

 

If you are using SNC SQL Native Client (OLE DB), please install Microsoft SQL Server 2012 Native Client.  Please select Download at https://www.microsoft.com/en-us/download/details.aspx?id=50402), and then select to install ENU\x64\sqlncli.msi. 

Best regards... Julie

Comment
There are no comments made yet.
  1. Monday, 19 November 2018
  2. PowerBuilder
  3. # 5
Jonathan Meltzer Accepted Answer Pending Moderation
0
Votes
Undo

So, you make a good point, but there is no 64-bit PBOLE170.DLL file included with 2017R3.  Is there a way to get it some other way?  I have tried to change the connection type to the server, but that is not working.

Comment
There are no comments made yet.
  1. Friday, 16 November 2018
  2. PowerBuilder
  3. # 6
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Jonathan;

  FWIW: Make sure that you have the 64bit version of the PB OLE DLL (and other run-times DLL's as well), deployed along with your App.

Regards ... Chris

Comment
There is no PBOLE170.DLL file in the C:\Program Files (x86)\Appeon\Shared\PowerBuilder\x64 directory. Where do I get a 64-bit DLL for OLE?
  1. Jonathan Meltzer
  2. Friday, 16 November 2018
Apparently this is a bug, from this thread: https://community.appeon.com/index.php/qna/q-a/dbms-oledb-is-not-supported-in-current-instalation-in-64-bits/voted



That was from a year ago. Has it been fixed? If not, what can I do?
  1. Jonathan Meltzer
  2. Friday, 16 November 2018
There are no comments made yet.
  1. Friday, 16 November 2018
  2. PowerBuilder
  3. # 7
  • Page :
  • 1


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