Hi Kevin, I'll double check but I believe the "v" Views are x86(32 bit only).

Thanks 

John Nichols

Sage

Hi John,

Thanks for the information. 

We recommend these views for Excel queries (more user friendly than joining tables), and 64-bit Office is becoming more and more common.  Sage has released 64-bit ODBC ProvideX drivers for a while now and I guess the views were not included in that effort.  Are there any plans to open these up for 64-bit ODBC?

The specific reason I'm asking is because a user has a new workstation, running an existing spreadsheet (with multiple queries) and one of the queries is broken on that machine.  The broken query is based on vItemWarehouse, and they use 64-bit Excel.

Kevin

(The number of similar issues we're getting with this is growing, as users are replacing their workstations in anticipation of Win7 end of support.  With 64-bit Excel on the SPM, it is hard to recommend 32-bit).

Hi Kevin, The Views system is interpreter based and the interpreter is x86. There may be a way we can deliver an x64 interpreter for use with the Views. I'll follow up on this thread next week.

Thanks John  

Hi Kevin,  I have a protype of this working with the x64 ODBC driver. I'll try and get this scheduled to include with the March 2020 release.

Thanks John

That is excellent news John.  Thanks!

Are you including this in v2020, and in the PU for v2019?

I can't answer which versions this will be included with "yet". I have through the scheduling process. Thanks John

(I expected it was too soon to know... just hinting that including in a v2019 PU / hotfix would be helpful).

Hi Kevin, x64 access to the views is included in 2020 and 2019 PU3. Thanks John

We have a number of customers that will be happy to hear this John.  Thanks again.