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

Resolved 64 bits executable and accessing Excel data

  1. Issue
0
Votes
Undo
  1. Philippe PILAT
    Philippe PILAT
  2. PowerBuilder
  3. Wednesday, 8 November 2017 16:19 PM UTC

My application is developed in PB 12.5 and migrated successfully to PB 2017. However there is a functionality to upload Excel files into a SQL Server DB. The code is :

 ltr_excel = CREATE TRANSACTION
 ltr_excel.DBMS = "OLE DB"
 ltr_excel.AutoCommit = TRUE
 ltr_excel.DBParm = "PROVIDER='Microsoft.ACE.OLEDB.12.0', DATASOURCE='" + ls_dir + "',PROVIDERSTRING='Excel 12.0; MaxScanRows=0;HDR=Yes;IMEX=1'"

 CONNECT USING ltr_excel;

Works perfectly in 32 bits but in a 64 bits exe, fails : "DBMS OLE DB is not supported in your current installation."

I understand that there is no 64-bit version of the PBOLE database interface but can you suggest another way to do it (which works in 32 and 64 bits) ?

 

TIA

Best regards.

  1. OLEDB
syntax of webservices
RegistryGet not finding entries due to VirtualStor...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 November 2017 16:52 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Philippe;

  Correct, the OLE interface is not yet supported in 64bit mode in PB 2017.

Have you tried using ODBC instead over to Excel?

Regards ... Chris

Comment
Philippe PILAT
  1. Philippe PILAT
  2. Thursday, 9 November 2017 09:06 AM UTC
Hi Chris,



Thank you for your prompt answer. It works with ODBC (both 32 & 64 bits).



You say "not yet supported", do you have any idea of when it will be supported.



 



Best regards,



Philippe.

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from 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.