• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to make 64-bit application use OLE DB successfully?

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

Resolved How to make 64-bit application use OLE DB successfully?

  1. Issue
0
Votes
Undo
  1. Jonathan Meltzer
    Jonathan Meltzer
  2. PowerBuilder
  3. Friday, 16 November 2018 19:08 PM UTC

 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.

  1. 64-bit
  2. DLL
  3. OLEDB
HTTPS for PostURL function of iNET Object in PB12....
How can I change a menu item visible property to f...
Responses (7)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 16 November 2018 19:26 PM UTC
  2. PowerBuilder
  3. # 1

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
Jonathan Meltzer
  1. Jonathan Meltzer
  2. Friday, 16 November 2018 19:29 PM UTC
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. Helpful
Jonathan Meltzer
  1. Jonathan Meltzer
  2. Friday, 16 November 2018 19:33 PM UTC
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. Helpful
There are no comments made yet.
Jonathan Meltzer
Jonathan Meltzer Accepted Answer Pending Moderation
  1. Friday, 16 November 2018 20:57 PM UTC
  2. PowerBuilder
  3. # 2

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.
Julie Jiang @Appeon
Julie Jiang @Appeon Accepted Answer Pending Moderation
  1. Monday, 19 November 2018 07:27 AM UTC
  2. PowerBuilder
  3. # 3

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.
Jonathan Meltzer
Jonathan Meltzer Accepted Answer Pending Moderation
  1. Monday, 19 November 2018 11:53 AM UTC
  2. PowerBuilder
  3. # 4

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
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 19 November 2018 17:54 PM UTC
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. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 20 November 2018 16:33 PM UTC
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. Helpful
Jonathan Meltzer
  1. Jonathan Meltzer
  2. Tuesday, 20 November 2018 16:38 PM UTC
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. Helpful
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 20 November 2018 05:49 AM UTC
  2. PowerBuilder
  3. # 5

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)
SNC SQL.png SNC SQL.png
Comment
There are no comments made yet.
Joseph Vendra
Joseph Vendra Accepted Answer Pending Moderation
  1. Tuesday, 11 June 2019 16:42 PM UTC
  2. PowerBuilder
  3. # 6

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 11 June 2019 17:11 PM UTC
  2. PowerBuilder
  3. # 7

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.
  • Page :
  • 1


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