1. 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.

Accepted Answer
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
  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.


There are replies in this question but you are not allowed to view the replies from this question.